Pausing the Macro

[Premanshu]

Hi,

Is there anyway i can pause the macro in between to allow the user to select a range on which the remaining part of the macro has to be performed.
like :-

sub xyz()
initial tasks to perform
'
'
pause to allow user to select range (as the excel functions allow)
'
'
Then the rest of the task to be performed on the selected range.
'
end sub

Please help me with this as i desparately need it to happen.


Regards
Premanshu.

 

[Legacy 68668]

try InputBox method

Application.InputBox("Select range", type:=8)

 

[VBA Noob]

Just to add this link has a good example

http://spreadsheetpage.com/index.php/tip/pausing_a_macro_to_get_a_user_selected_range/

VBA Noob

 

[Premanshu]

Seiya, VBA Noob you guys are really genius. This exactly is what i was searching for. Thanks a lot for guiding me the right way. Can you guys also advice me some site where i can explore more of this kind (i.e the types of inputboxes and more).

Thanks you so much again for being there. >

Regards
Premanshu.

 

[Legacy 68668]

You can just get information from vb help file.

Search the with key word "Inputbox"

There are 2 types.

InputBox function
InputBox method