Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Answer Validation Problem
If this is the exit event of the Required field, then setting cancel = True
should cause the cursor not to leave the field/textbox. Perhaps you could query in your msgbox "Switch values?" and just switch them if the response is positive. -- Regards, Tom Ogilvy "WillRn" wrote in message ... Hello All, I have a userform that tabulates the number of times a task was required versus the number of times the task was actually done. A lot of my users have been transposing numbers so I thought I would validate that the required value is equal or greater than the done value. So I wrote the following line of code and attached it to the Exit event for the field. If QCMonitor.QC1Done.Value QCMonitor.QC1Req.Value Then Response = MsgBox("Your 'Done value' is greater that your 'Required value.'" )Cancel = True QCMonitor.QC1Req.SetFocus End If Problem is I can't get the cursor to go back to the Required field. I keep getting a "Run-Time Error '-2147467259 (80004005)': Unspecified Error" Any ideas on how to fix this? Will |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Must Answer Data Validation Question | Excel Discussion (Misc queries) | |||
Userform Answer Validation Problem | Excel Programming | |||
Userform with validation... | Excel Programming | |||
Userform Validation | Excel Programming | |||
Userform Date validation | Excel Programming |