Input mask on a form in Excel 2003

[Lloyd]

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

[Tom Ogilvy]

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

[Lloyd]

Hi Tom
where do I find change event for the textbox.

Thanks

"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

[Lloyd]

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

[Tom Ogilvy]

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

[Lloyd]

Yes I mean userform in a VBAProject (TextBox)

"Tom Ogilvy" wrote:

> 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

[Tom Ogilvy]

double click on the textbox in the VBE and it should take you to the change
event. Or right click on it and select view code.

--
Regards,
Tom Ogilvy


"Lloyd" wrote:

> Yes I mean userform in a VBAProject (TextBox)
>
> "Tom Ogilvy" wrote:
>
> > 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