input mask for texboxes

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.
 
D

Dave Peterson

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.
 
M

michael sofianos

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...
 

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

Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
Time format hh:nn drops leading zero 0
Invoicing and customer database 0
How to modify and updte specific styles for specific paragraphs across the document 0
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
decimal time data entry 5
A03- Date format in tables? 1

Top