User Form

[vextax21]

When using a VBA userform with Excel is it possible to have input masks on textboxes? The textboxes are linked directly to an excel worksheet. I would like to know if it was possible to store and validate the data befor it reaches the worksheet.

Any insights on UserForms would be greatly appreciated

thx

 

[Dreamboat]

Go here:

http://www.theofficeexperts.com/downloads.htm#ExcelDownloads

And scroll down a bit to download UserformTraining...

I'm looking for something more specific in the meantime.

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts

 

[csniffer]

It is pos to validate but cannot tell u how because I don’t know what u r testing boxes 4 please amend, as 4 storing the info from boxes just store 2 a variable, I have assumed u know VBA because I think u r using a home made form but if u don’t know how to do this just add that as well and I will look tm to see how u r getting on.