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!

Register Log in
  • Congratulations Mike Lewis 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

hopp

Programmer
May 22, 2006
7
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?
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Never got to say thanks yesterday.

Thank you :)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
376
strongm
strongm
remeng
  • Locked
  • Question
Application.FileSearch replacement
Replies
16
Views
526
remeng
remeng
thanhthanh12
  • Locked
  • Question
Create a application in word vba
Replies
3
Views
124
combo
combo
MattGreer
  • Locked
  • Question
Application Lockups During Code Execution 4
Replies
9
Views
169
MattGreer
MattGreer
DBDivaAuto
  • Locked
  • Question
Breaking the VBA Password in Access
Replies
3
Views
255
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top