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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting MM-DD HH:MM out of Julian date 4
Input mask for date! 0
count days hours and minutes 13
Input Mask - Date and Time 7
Userform input question 4
Input Mask in 2003? 1
Input Mask Help 1
Help with formula 1

Back
Top