Yes, I understand that. I assumed you mean using userform or a textbox from
the control toolbox toolbar. If not, where do you want to validate the data?

If you mean in a cell, then look at Data=Validation

--
Regards,
Tom Ogilvy




"Lloyd" wrote:

Hi Tom

Sorry maybe I did not explain myself. I am working in Excel VBA

"Tom Ogilvy" wrote:

there is no support for this. You would need to use the change event for the
textbox to validate the entry.

--
Regards,
Tom Ogilvy


"Lloyd" wrote:

Hi My name is Lloyd
I know MS Access quite well, can you help me I want to put input mask to a
date on a field in a form in Excel eg. 2006/08/08.

Thanks