How do I pause a macro to select specific cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using version Excel 2003 - I need to be able to pause a macro to allow
me to select specific cells (which will be different each time I use the
macro) then continue to run the rest of the macro.
 
You could use application.inputbox()

As in:

dim myRng as range

set myrng = nothing
on error resume next
set myrng = application.inputbox("Select a range", type:=8)
on error goto 0

if myrng is nothing then
'user hit cancel
'what happens here
else
msgbox myrng.address 'do what you want
end if
 

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

VBA macro pausing 2
How do I get a macro to be non worksheet specific? 6
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
pausing a macro to input cell contents 3
Pasting cell contents into a macro 1
Can a macro be paused to allow input, then continue? 2
pause a macro 9
Highlight selected cells only 4

Back
Top