| 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 | |||
Linear Mode
