R
Rod Taylor
I have a Textbox that is used for a Time Input
I want the user to only be allowed to enter the info in the right format
I.a. 12:30 I think the part that is important is the : in the middle.
Also when the user clicks the command button An if statement is run to
verify that all fields have been filled in. If not then a msgbox comes up
stating that all info must be filled in.
The problem is when the msgbox is closed then the unload me is run and the
info that was put in is acted on
I fixed that by making all variables = "" However the form still closes
and needs to be run again.
Is their a way to allow the user to fill in the remaining boxes if the if
statement is true. Or is there another way
Thanks Rod Taylor
Also when I put the time variable into a cell and later get that info from
the cell putting it into a variable again the time format changes to a
decimal instead of time any help on this please.
I want the user to only be allowed to enter the info in the right format
I.a. 12:30 I think the part that is important is the : in the middle.
Also when the user clicks the command button An if statement is run to
verify that all fields have been filled in. If not then a msgbox comes up
stating that all info must be filled in.
The problem is when the msgbox is closed then the unload me is run and the
info that was put in is acted on
I fixed that by making all variables = "" However the form still closes
and needs to be run again.
Is their a way to allow the user to fill in the remaining boxes if the if
statement is true. Or is there another way
Thanks Rod Taylor
Also when I put the time variable into a cell and later get that info from
the cell putting it into a variable again the time format changes to a
decimal instead of time any help on this please.