View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris D[_2_] Chris D[_2_] is offline
external usenet poster
 
Posts: 10
Default VBA code for MsgBox

For the following script I get an inputbox for which the user has to enter a
number:
Dim result As Long

result = Application.InputBox("Enter Number of Days which are in this
report( highest number of worksheets in document", "Days in Report")

Select Case result
Case 1
Columns("T:CJ").Select
Case 2
Columns("U:CJ").Select
Case 3
Columns("V:CJ").Select
Case Else
MsgBox "please enter a valid number"

End Select

I would like the macro to exit the sub when "cancel" is selected.
Can anyone help me with this?