Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InputBoxes & Ranges
Dear Friends,
I posted this question last week. Although a friend tried to help he couldn't do so. Sure would oblige if any1 else could help me outta this mess: 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 As Range, SECOND As Range, 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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranges & Inputboxes? | Excel Programming | |||
userform and inputboxes | Excel Programming | |||
connecting 2 inputboxes and using the autofill | Excel Programming | |||
InputBoxes | Excel Programming | |||
InputBoxes Exceptions | Excel Programming |