Prompting User
 

Anyone know of a way to get a macro to promot a user for input?

Prompting User
 

Look in VBA help for MSGBOX()
--
Gary''s Student


"Alexis" wrote:

Anyone know of a way to get a macro to promot a user for input?

Prompting User
 

see InputBox

HTH
--
AP

"Alexis" a écrit dans le message de
...
Anyone know of a way to get a macro to promot a user for input?

Prompting User
 

Thank you! Know of a way to have the response put onto the worksheet?

"Ardus Petus" wrote:

see InputBox

HTH
--
AP

"Alexis" a écrit dans le message de
...
Anyone know of a way to get a macro to promot a user for input?

Prompting User
 

from the help file:

mynum = Application.InputBox("Enter a number")
Range("a5") = mynum

--


Gary


"Alexis" wrote in message
...
Thank you! Know of a way to have the response put onto the worksheet?

"Ardus Petus" wrote:

see InputBox

HTH
--
AP

"Alexis" a écrit dans le message de
...
Anyone know of a way to get a macro to promot a user for input?

Prompting User
 

Try this
With Worksheets("Sheet1")
If TextBox.Text < "" Then
Range("A1").Select
Application.Selection.Value = tbName.Text
Cancel = False
Else: MsgBox "Please enter data."
End If
"Alexis" wrote in message
...
Thank you! Know of a way to have the response put onto the worksheet?

"Ardus Petus" wrote:

see InputBox

HTH
--
AP

"Alexis" a écrit dans le message de
...
Anyone know of a way to get a macro to promot a user for input?

Prompting User
 

Thank You Thank You Thank You!!!

"Gary Keramidas" wrote:

from the help file:

mynum = Application.InputBox("Enter a number")
Range("a5") = mynum

--


Gary


"Alexis" wrote in message
...
Thank you! Know of a way to have the response put onto the worksheet?

"Ardus Petus" wrote:

see InputBox

HTH
--
AP

"Alexis" a écrit dans le message de
...
Anyone know of a way to get a macro to promot a user for input?