How do I get an excel macro to stop at a cell & wait for imput?
What can be used to replace the "{?}" command used in lotus macros to pause
and wait for data entry? The lotus macro worked fine in excel 97 but after switching to excel 2003 did not. |
How do I get an excel macro to stop at a cell & wait for imput?
You can use the inputbox, as in:
Sub test() Dim YourInput As String YourInput = InputBox("What is your input?") MsgBox ("Your input was " & YourInput) End Sub "oscar_az" wrote: What can be used to replace the "{?}" command used in lotus macros to pause and wait for data entry? The lotus macro worked fine in excel 97 but after switching to excel 2003 did not. |
All times are GMT +1. The time now is 03:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com