|
-
Nov 10th, 2003, 05:33 PM
#1
Thread Starter
New Member
Testing for cell values in Excel 97 ?
I need to test the value in a cell that currently has validation turned on values displayed in a
list (combo box)
The routine in VBA is as follows:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
WorkID = ActiveCell().Text
If WorkID = "Flex" Then MsgBox "Please complete Flex-Time Form"
End Sub
My problem is that it only fires when I leave the cell and return back...How can I test the value in cell before, or as, I get to the next cell?
This is Excel '97
Thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|