Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro pause for a data entry before finishing?
Can a macro pause for a data entry before finishing?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro pause for a data entry before finishing?
You can use an InputBox to take the new data in... the program will pause
for the user to enter the value... Dim NewData As Variant .... .... NewData = Application.InputBox("Give me the new data.") ' ' Do whatever you want with the contents of the NewData ' variable. You may want to check to make sure the user ' actually entered a value before attempting to use the value. ' -- Rick (MVP - Excel) "Fan924" wrote in message ... Can a macro pause for a data entry before finishing? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro pause for a data entry before finishing?
In short... No. there are a few techniques I have seen posted but in general
they all have pretty significant drawbacks. Here is what you can do 1. Use an input box to get info from the user (good if you only want really simple input) 2. Use a user form to get user input (good for more complex input) 3. End the macro at the point of requireing input. Catch change events occuring in the spreadsheet to initiate the final code. -- HTH... Jim Thomlinson "Fan924" wrote: Can a macro pause for a data entry before finishing? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro pause for a data entry before finishing?
x = Inputbox( )
or x=Application.Inputbox( ... ) "Fan924" wrote in message ... Can a macro pause for a data entry before finishing? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a macro pause for a data entry before finishing?
Thanks guys
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I write an Excel macro to pause for data entry then continue? | Excel Discussion (Misc queries) | |||
Stop / Pause a Macro using Pause button | Excel Programming | |||
Pause for data entry | Excel Programming | |||
Macro Pause during Dialog Box data entry | Excel Discussion (Misc queries) | |||
Programing a macro to pause while running for data entry | Excel Programming |