Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to have this check the rng(1, 5) for a value.
If the value is blank I need to fire a msgbox "Sorry but you have clicked to far down on the worksheet. Please select the next blank row." If the value is not blank then show the UserForm. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If bSELCTIONCHANGE Then If Not Application.Intersect(Target, Range("B3:M5000")) Is Nothing Then Lost_And_Found.Show End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Test For BLANK Range | Excel Programming | |||
Test within a range? | Excel Worksheet Functions | |||
range as test | Excel Programming | |||
Can't test Range for Nothing | Excel Programming | |||
== How to test if a range var contains nothing | Excel Programming |