choosing dates on userform
 

Is there anyway that you can put a calender in a userform so when a use
wants to change the date they can click the date and that will defaul
to the text box value instead of manual entry.

Thank

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=37579

choosing dates on userform
 

Take a look at the activex control "mscal.ocx"

--
Cheers
Nigel



"jhahes" wrote in
message ...

Is there anyway that you can put a calender in a userform so when a user
wants to change the date they can click the date and that will default
to the text box value instead of manual entry.

Thanks


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=375797

choosing dates on userform
 

Is there a way to load this on to other machine if they do not have it useing
vba code?

"Nigel" wrote:

Take a look at the activex control "mscal.ocx"

--
Cheers
Nigel



"jhahes" wrote in
message ...

Is there anyway that you can put a calender in a userform so when a user
wants to change the date they can click the date and that will default
to the text box value instead of manual entry.

Thanks


--
jhahes
------------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=375797