Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW TO PUT MSGBOX CODE IN MACRO | Excel Programming | |||
Msgbox Code Help Please.... | Excel Discussion (Misc queries) | |||
Code for MsgBox | Excel Programming | |||
VBA code using if then and msgbox | Excel Discussion (Misc queries) | |||
syntax for code in MsgBox()? | Excel Programming |