Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
defining an event procedure (lostfocus) that works on a column range
I am trying to write an event procedure that works for an
entire column (lostfocus). private sub a_LostFocus() works when I run the program but not generally in excel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
defining an event procedure (lostfocus) that works on a column range
juhlott,
You could use the selection change event, along the lines of this, to show when at least one cell in column A is not selected: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Range("A:A"), Target) Is Nothing Then Exit Sub MsgBox "You haven't selected a cell in column A" End Sub HTH, Bernie MS Excel MVP "juhlott" wrote in message ... I am trying to write an event procedure that works for an entire column (lostfocus). private sub a_LostFocus() works when I run the program but not generally in excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining Named Range for Lastrow in a specific column | Excel Discussion (Misc queries) | |||
workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
Same event procedure for multiple controls | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |