Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including prompts in macros
I'd like to write a macro where it prompts me to enter a value for a cell
half way through without stopping. For example, I might like to include a date once a set of data has been manipulated, after entering this, I'd like the macro to continue running. Is there a way Excel can do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including prompts in macros
hi,
yes there is a way. assuming cell = A1 Private Sub inputdate() Range("A1").value = inputbox("enter a date") end sub adjust A1 for the cell you want the date input to. you didn't include enough info to write more of the macro. Regards Frank -----Original Message----- I'd like to write a macro where it prompts me to enter a value for a cell half way through without stopping. For example, I might like to include a date once a set of data has been manipulated, after entering this, I'd like the macro to continue running. Is there a way Excel can do this? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including prompts in macros
one way:
Dim vResponse As Variant Do vResponse = Application.InputBox( _ Prompt:="Enter Date:", _ Title:="Date Entry", _ Default:=Format(Date, "mm/dd/yyyy"), _ Type:=2) If vResponse = False Then Exit Sub 'User cancelled Loop Until IsDate(vResponse) In article , BeardT wrote: I'd like to write a macro where it prompts me to enter a value for a cell half way through without stopping. For example, I might like to include a date once a set of data has been manipulated, after entering this, I'd like the macro to continue running. Is there a way Excel can do this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including prompts in macros
look at InputBox in VBA help
-- HTH RP "BeardT" wrote in message ... I'd like to write a macro where it prompts me to enter a value for a cell half way through without stopping. For example, I might like to include a date once a set of data has been manipulated, after entering this, I'd like the macro to continue running. Is there a way Excel can do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save Prompts | Excel Worksheet Functions | |||
Formula Prompts | Excel Discussion (Misc queries) | |||
Saving Prompts | Excel Worksheet Functions | |||
Prompts | Excel Discussion (Misc queries) | |||
formula prompts | Excel Discussion (Misc queries) |