User Form - Input mask

Posted by Tee on June 26, 2001 3:25 PM

Hi Everyone

I have a user form that loads when called - I would like 1 text box to display the input mask (like in Access)V _ _ _ _ _ _

So as when the user enters a number the V will already be there and they know how many numbers to enter by the _

Many Thanks in advance for any help.

Tee

Posted by Kevin James on June 26, 2001 3:50 PM

Tee:

In Excel, input boxes are type: Variant. You can designate a default value of "V" but not the length. You can add error trapping that would tell the user the input was wrong and recycle for re-input.

Posted by Tee on June 26, 2001 7:20 PM

More info Pls.

**********
Hi Kevin - can you in this in simple terms. What line of code I would need to add and where I would need to place it. attached to the textbox or on the form load event.

I am not very good at VB coding or just coding in the general sence.

Thanks Tee.

Posted by Kevin James on June 26, 2001 10:02 PM

Teaching

Hello Tee:

I have this life-principle I live by: Give a man a fish and you feed him for a day. Teach him how to fish and you feed him the rest of his life."

When I first responded to your post, I got the impression you did understand VBA. Try looking here for training assistance:

http://support.microsoft.com/support/excel/content/vba101/default.asp

Posted by tee on June 26, 2001 10:50 PM

Re: Teaching - THANKS FOR THAT !!!!!!

http://support.microsoft.com/support/excel/content/vba101/default.asp

Fishing is easier than VB - ALOT would agree