Format Textbox on an user input form

  • Thread starter Thread starter Roget168
  • Start date Start date
R

Roget168

I created an input form in Excel where an user will enter sales transactions.
It contains textbox for date, price and qty. Is there a way to format these
box to match Date, Currency and Integer inputs only?

Thanks in advance.
 
Since no one else has replied yet, I'll take a swing at this, by asking a
question: In a text box is displayed whatever characters the user's fingers
strike on the keyboard. So do you mean you want the text box to show not
what the user typed, but some valid Date/Currency/Integer equivalent? or if
the user types (for example) an 'X', do you want it to refuse to accept that
character, perhaps beeping at him instead? or do you want to spot an invalid
entry and display an error message as soon as he hits <Enter>? or do you just
want to accept proper input and convert it to the correct
Date/Currency/Integer storage? or what?
 
Back
Top