input mask for texboxes

  • Thread starter Thread starter michael sofianos
  • Start date Start date
M

michael sofianos

Hello,

I try to fix an input mask for hours + minutes in userform in textbox with
VBA. For example when the user try to inpur hh:mm to see __:__ and after
that , to need to input hour (for example 12) and minute (for example 23)
12:23.
 
About the best you can do in excel is format the textbox after the user has left
the textbox.

Maybe you could use a some other control (combobox/spinner/listbox) to select
the hour and minute. Then the user wouldn't even have to type.
 
many thanks for information




Dave Peterson said:
About the best you can do in excel is format the textbox after the user
has left
the textbox.

Maybe you could use a some other control (combobox/spinner/listbox) to
select
the hour and minute. Then the user wouldn't even have to type.
Click to expand...
 
Back
Top