Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I always get into a trouble when referring to a range via an inputbox and a
Cancel button is clicked or it is left Blank. Any suggestions? Furthermore, what might be wrong with the following code? Sub CHECK() Dim FIRST, SECOND, THIRD As Range Set FIRST = Application.InputBox("FIRST!", , , , , , , 8) If FIRST.Address = "" Then Exit Sub MsgBox "--:" & FIRST.Address & ":--" End If Set SECOND = Application.InputBox("SECOND!", , , , , , , 8) If SECOND.Address = "" Then Exit Sub MsgBox "--:" & SECOND.Address & ":--" End If Set THIRD = Application.InputBox("THIRD", , , , , , , 8) If THIRD.Address = "" Then Exit Sub MsgBox "--:" & THIRD.Address & ":--" End If End Sub -- Best Regards, Faraz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
userform and inputboxes | Excel Programming | |||
Positioning Userforms, InputBoxes | Excel Discussion (Misc queries) | |||
connecting 2 inputboxes and using the autofill | Excel Programming | |||
InputBoxes | Excel Programming | |||
InputBoxes Exceptions | Excel Programming |