how to format a date/validate for a text box entry on a user form
 

There is no built in validation. You have to use events such as Exit or
AfterUpdate where you place your code to validate the entry.

--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Could someone please tell me how to validate a date entered on a user form
and also how copy in the appropriate format back to the worksheet. On the
worksheet the existing dates are in format May-14-97 by setting it in a
custom format. These were entered manually.. Now the worksheets fields
encompass more of the worksheet so it necessitated a user form for ease of
viewing/changing/adding/deleting. The date when entered is not based
necessarily on today's date.. as most dates are in the past.. since archived
information is being consolidated into a spreadsheet so it can be found in
one spot.

Thanks

how to format a date/validate for a text box entry on a user f
 

An example of validating a textbox:

http://support.microsoft.com/default.aspx?kbid=213555
XL2000: No Data Validation Property for UserForm TextBoxes

A genearl reference to solve a wealth of problems:

http://support.microsoft.com/default...Product=xl2002
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Thank you... I understood that.. but wanted an idea of how to check I
guess... Could you point to an example of that perhaps.. ?

Oh, and thanks for all your help.... I appreciate it.. You have answered
several questions for me and although sometimes it wasn't exactly what I was
looking for per se (since you are not a mind reader..).. but its put me on
the right track... to finding what I really need.

"Tom Ogilvy" wrote:

There is no built in validation. You have to use events such as Exit or
AfterUpdate where you place your code to validate the entry.

--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Could someone please tell me how to validate a date entered on a user
form
and also how copy in the appropriate format back to the worksheet. On
the
worksheet the existing dates are in format May-14-97 by setting it in a
custom format. These were entered manually.. Now the worksheets fields
encompass more of the worksheet so it necessitated a user form for ease
of
viewing/changing/adding/deleting. The date when entered is not based
necessarily on today's date.. as most dates are in the past.. since
archived
information is being consolidated into a spreadsheet so it can be found
in
one spot.

Thanks

how to format a date/validate for a text box entry on a user f
 

Thanks again .. I ultimately found my solution in VB Help... and now I found I could format it saving and loading the data on the form.... I just must finally hit upon the right wording to my problem when I tried to find the solution there before...


"Tom Ogilvy" wrote:

An example of validating a textbox:

http://support.microsoft.com/default.aspx?kbid=213555
XL2000: No Data Validation Property for UserForm TextBoxes

A genearl reference to solve a wealth of problems:

http://support.microsoft.com/default...Product=xl2002
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Thank you... I understood that.. but wanted an idea of how to check I
guess... Could you point to an example of that perhaps.. ?

Oh, and thanks for all your help.... I appreciate it.. You have answered
several questions for me and although sometimes it wasn't exactly what I was
looking for per se (since you are not a mind reader..).. but its put me on
the right track... to finding what I really need.

"Tom Ogilvy" wrote:

There is no built in validation. You have to use events such as Exit or
AfterUpdate where you place your code to validate the entry.

--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Could someone please tell me how to validate a date entered on a user
form
and also how copy in the appropriate format back to the worksheet. On
the
worksheet the existing dates are in format May-14-97 by setting it in a
custom format. These were entered manually.. Now the worksheets fields
encompass more of the worksheet so it necessitated a user form for ease
of
viewing/changing/adding/deleting. The date when entered is not based
necessarily on today's date.. as most dates are in the past.. since
archived
information is being consolidated into a spreadsheet so it can be found
in
one spot.

Thanks

how to format a date/validate for a text box entry on a user f
 

Cheryl,

What did you do to get this to work?


"Cheryl" wrote:

Thanks again .. I ultimately found my solution in VB Help... and now I found I could format it saving and loading the data on the form.... I just must finally hit upon the right wording to my problem when I tried to find the solution there before...


"Tom Ogilvy" wrote:

An example of validating a textbox:

http://support.microsoft.com/default.aspx?kbid=213555
XL2000: No Data Validation Property for UserForm TextBoxes

A genearl reference to solve a wealth of problems:

http://support.microsoft.com/default...Product=xl2002
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Thank you... I understood that.. but wanted an idea of how to check I
guess... Could you point to an example of that perhaps.. ?

Oh, and thanks for all your help.... I appreciate it.. You have answered
several questions for me and although sometimes it wasn't exactly what I was
looking for per se (since you are not a mind reader..).. but its put me on
the right track... to finding what I really need.

"Tom Ogilvy" wrote:

There is no built in validation. You have to use events such as Exit or
AfterUpdate where you place your code to validate the entry.

--
Regards,
Tom Ogilvy


"Cheryl" wrote in message
...
Could someone please tell me how to validate a date entered on a user
form
and also how copy in the appropriate format back to the worksheet. On
the
worksheet the existing dates are in format May-14-97 by setting it in a
custom format. These were entered manually.. Now the worksheets fields
encompass more of the worksheet so it necessitated a user form for ease
of
viewing/changing/adding/deleting. The date when entered is not based
necessarily on today's date.. as most dates are in the past.. since
archived
information is being consolidated into a spreadsheet so it can be found
in
one spot.

Thanks