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?
|