Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I have a 1-2-3 macro that pauses so the user can enter data into a certain cell. How can I get the same effect in a VBA macro?

April 26, 2017CELL certain Data enter macro pauses user VBA

0

Posted

I have a 1-2-3 macro that pauses so the user can enter data into a certain cell. How can I get the same effect in a VBA macro?

1 Answer

0

Posted

Excel can’t duplicate that type of behavior, but you can use Excel’s InputBox statement to get a value from a user and place it in a particular cell. The statement below, for example, displays an input box. When the user enters a value, that value is placed in cell A1.