MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel macro comand

Posted by Jim on August 30, 2001 3:22 PM

In Quatro, you can move to a cell through the use of a macro, pause until a keyboard entry is made, and when you press the enter key, the macro will proceed. This is done with the {?} macro feature.
I have not been able to find out if Excel has this ablity. My macro will do everything I need EXCEPT pause for keyboard entry.
Is there a good book that will cover the Excel macro comands in greater depth than clippy.

Posted by Dexter on August 31, 2001 3:49 AM

Posted by Dexter on August 31, 2001 5:14 AM

Hi Jim,
Let me try this reply booted off the network in middle of last reply. Try EXCEL POWER PROGRAMMING WITH VBA by John Walkenbach.
I'm a former Lotus macro writer struggling with VBA.

Here is a simple Code for obtaining user input:

Range("A1") = InputBox("Enter the Number")

This will pause the macro, ask user to enter a number, and enter the number in cell A1 of active worksheet.

Good luck