Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

break application

Status
Not open for further replies.

hopp

Programmer
Joined
May 22, 2006
Messages
7
Location
US
Was wondering whats the command that i can pause the macro in excel so the user can select another group of columns then it contineues excecuting the code. Anyone have any help?
 
straight from the VBA help:
Set myRange = Application.InputBox(prompt := "Sample", type := 8)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Never got to say thanks yesterday.

Thank you :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top