Calendar...

[diamondpony]

First, this is not a textbox from the forms tools bar. This is a tex
box from the Control toolbox which requires basic VBA coding.

How to I write a code that automatically formats the toolbox for mm d
yyyy...I can't get it.

Would it easier to design a user form for a pop-up calendar. BUt, the
I'd have to write code to initialize the form, make the date go into th
insertion points and all the other headaches....

Can anyone help does anyone have a suggestion.

... :confused

 

[Doug Robbins]

Use the Exit event of the text box to apply the Format() function

mytextbox = Format(mytextbox, "mm dd yyyy")

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP