VBA Tips - Turn Off Message Boxes Whilst Running Code

I have a macro that I need a hand with. The form that users fill out contains 1 string that actually contains 2 different commands I need separated. For example, the text the user puts in is "text1*text2", and I need it to be "text1" and "text2". I wrote in code to do delimited text-to-columns with * as the separator, and that works great but Excel prompts the user with "Do you wish to replace the contents of the destination cells". The answer is always yes, so is there a way I can make it just not pause & ask that?

Hi all,

I'm new to the forum and couldn't find any good tips for speeding up my program, but I'm hoping there's someone who can help. I'm writing this for a school project in my Heat Transfer class. m and n are coordinates, m range from 1 to 31, n range from 1 to 41 and I need to output a temperature (Tnode) for every (m,n) coordinate. Tau, Time, and Tstep are user inputted, but they can be .225, 20, and .2, respectively. I'm running Excel07/Win7/4GB ram/2.4GHz duo if that matters.

Hi,

I need a message box with information before the code run. Yes - code run, No - exit code.

TIA

RAM

Hi,

You may have answered before, but I didn't know what to search under. When I run my userform, the excel sheet behind becomes locked down and you have to come out of the marco to edit.

I have used third party macros that don't suffer this problem, anyone know how to do it?

Regards,

Martin

I have a userform which has over 70 checkboxes. Each check box represents a location which when checked filters a table (table1).

Example: If I have checked only three check boxes (like Phoenix, New York, Las Angelas check boxes) then table1 will show only those items that are in those locations.

I want to keep the macro as short and simple as possible.
Any suggestions?

Thanks

Nicole

I am running into an error when running this code. I have created a userform where I am trying to keep the input in a "mm/dd/yy" format. The user enters in the value into Textbox12 on the form. Any help is appreciated.

Code:

Private Function DateIsValid(Texbox12 As String) As Boolean
  Dim s As String, d As Date, x
  s = Me.Controls(Texbox12)
  ' Date value test
  On Error Resume Next
  x = Split(s, "/", -1, vbTextCompare)
  d = DateSerial(x(2), x(0), x(1))
  DateIsValid = Err = 0 And Len(s) > 0 And Len(s) = 8
  ' Error message
  If Not DateIsValid Then
    Me.Controls(Texbox12).SetFocus
    MsgBox "Please specify start data in a mm/dd/yy date format.", vbCritical, "Error"
  End If
End Function

Hi,

I am writing a macro to control calculation. At the moment we get users pressing F9 to recalc a worksheet and then, if it runs slowly, they press it mutliple times before the recalc finishes. This has the effect of queing up multiple recalcs.

I am wondering if there is a way to capture the keystrokes while the macro is running? Hence if the user pressed F9 when the recalc macro was already running I could capture this and trigger another macro.

Hope you can help...

Hi All,

I have a macro to show a UserForm - a sort of 'Control Window' that I use to control various other macro's that affect a specified spreadsheet in various ways by clicking buttons within the form.

One of these functions copies data as values from one sheet and pastes it into another. Once its there though I want to be able to copy the data or save the sheet. But Excel won't let me for some reason and I presume its because the 'Control Window' is still visible. Is there some way of getting around this?

Thanks,

Pat

Hello All

How do I keep a running total or count displayed at the bottom of a column when I have used the Autofilter?

Hi, I have some code which takes around 10 seconds to run when a
spreadsheet opens and I want to display a basic userform with the word
"Calculating..." showing.

I have managed to do this by adding the code under form_load, and
calling the form when the spreadsheet opens - therefore the spreadsheet
opens, the userform is displayed and the code runs.

This is fine but ideally i would just like to be able to have the
facility to run a macro and have a form display in the foreground in a
straight-forward way.

Can this be done?

Thanks!