MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pause for entry


Posted by Bob Slater on December 27, 2001 4:40 PM

I'm totally new to Excel and have been given the task of converting our Lotus worksheets to Excel. Can anyone tell me how to pause the execution of a macro to allow for input and then resume the execution. The command sequence in Lotus is {?}~ but I can't find an equivelant command in Excel.

Also is there a list of Excel commands or a list of Lotus to Excel comperable commands available anywhere?


Posted by Jacob on December 27, 2001 4:44 PM

What type of input?

try this

Dim MyInput

MyInput = inputbox("Input Some Information")

then you can refer to MyInput to use the value in your code.

If you want to pause to select a range try

MyInput = application.inputbox("Make a Selection")

Hope this helps

Jacob

Posted by Joe Was on December 28, 2001 6:42 AM

You must use the InputBox method or the sendKeys command to get input from the user. JSW