PDA

View Full Version : Input mask



ericc
04-07-2008, 01:44 PM
Hi

Again a stupid idea, but could be great :

Is it possible to create an input mask in a cell as in Access.

I have a column, where the user is supposed to enter values. But the values should be formatted like this :
00.XX.000000
(2 digits) + dot + (2 capital letters) + dot + (6 digits)

Is it possible to force the user to respect strictly this format ? (and reject any other input)
(without a macro ? :whistle:)


Thanks in advance for your help

ericc

rory
04-07-2008, 02:16 PM
You could do it with a complicated Data Validation formula but it would be easier with VBA if that's an option?

ericc
04-07-2008, 11:32 PM
Hmm, Apparently I will not have the choice ...

I just wonder why Excel don't have a better input mask feature as Access, when users are supposed to enter values :think:

Thanks anyway

ericc

rory
04-08-2008, 06:21 AM
Access is a database program, Excel isn't. You can use data validation, or you can use userforms to assist with data entry but you won't find a lot of the features of a database program in Excel because that's not really what it's for, even if people do use it that way.