Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Require data entry in column before moving to next cell
I found the following code which is exactly what I need but am unsure
how to change it to apply to all of Column A? Private Sub Worksheet_SelectionChange(ByVal Target As Range) Set b9 = Range("B9") Set t = Target If Intersect(t, b9) Is Nothing Then If checkit Then If b9.Value = "" Then Application.EnableEvents = False b9.Select Application.EnableEvents = True Else checkit = False End If End If Else checkit = True End If End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Require data entry in column before moving to next cell
Maybe this
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 1 Then MsgBox "Do Something" End If End Sub Mike " wrote: I found the following code which is exactly what I need but am unsure how to change it to apply to all of Column A? Private Sub Worksheet_SelectionChange(ByVal Target As Range) Set b9 = Range("B9") Set t = Target If Intersect(t, b9) Is Nothing Then If checkit Then If b9.Value = "" Then Application.EnableEvents = False b9.Select Application.EnableEvents = True Else checkit = False End If End If Else checkit = True End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Require an entry in a cell | Excel Discussion (Misc queries) | |||
Data Validation- Require Entry in a Field | Excel Discussion (Misc queries) | |||
Need ComboBox to require entry before moving to next control | Excel Programming | |||
How do I require data entry in a cell before moving to the next ce | Excel Worksheet Functions | |||
Require cell entry | Excel Programming |