Pausing a macro for user input

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

What is the command to pause a macro so user can input a
line number that changes with each use of the
spreadsheet. Old Lotus command was {?}
 
Wayne,

Try this:

Dim x As Long
x = InputBox("What line?", "")
Rows(x).Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a macro that opens, edits then closes cell 1
Stop / Pause a Macro using Pause button 4
Stop Command Question 4
pausing macro while cells update 6
Funcitonality to pause macro?! 13
how to pause a 'save-as' and continue after input 2
Pause Macro 4
Pause a macro for user input 15

Back
Top