I have a userform in which the user selects an individual's name from a combobox (ce_name), and then enters the start (ce_start) and end (ce_end) times in two proceeding textboxes. These two time values are checked then to see whether they are valid times. (custom function onExit)
The problem I'm having is bypassing the time validation check when the user selects "Not staffed" from the combobox. If the user selects "Not staffed", I have the time start and time stop defaulting to an "X". Well ... you can see the problem. Although I want an "X" in this scenario, the validation check disallows it.![]()
Please Login or Register to view this content.
What might you suggest I need to add to provide a bypass when ce_name = "Not staffed", or ce_start / ce_end equal "X"?![]()
Please Login or Register to view this content.
Thank you in advance.
Jenn
Bookmarks