| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompting User
Anyone know of a way to get a macro to promot a user for input?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prompting user to enable a link | Excel Discussion (Misc queries) | |||
| Prompting a user to open Read Only | Excel Programming | |||
| User/pass prompting code | Excel Programming | |||
| Prompting user before saving | Excel Programming | |||
| Prompting user before saving | Excel Programming | |||
Linear Mode
