Hi!
I'm using the Microsoft Calendar Control Version 11.0. and I have
forgotten how to keep it visable while I select another cell to input a
date into. Currently I must close the calendar, select the cell I want
to input and then activate the calendar and click on the date.

I currently have one in a different workbook and it works fine but when
I copied it over to the new workbook it quit working.

Can someone help? Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=544476

Drop the calendar control on to a userform and show the form
modelessly:

UserForm1.Show vbModeless


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Brian Matlack"

wrote in message
news:Brian.Matlack.288bym_1148335802.3517@excelfor um-nospam.com...

Hi!
I'm using the Microsoft Calendar Control Version 11.0. and I
have
forgotten how to keep it visable while I select another cell to
input a
date into. Currently I must close the calendar, select the cell
I want
to input and then activate the calendar and click on the date.

I currently have one in a different workbook and it works fine
but when
I copied it over to the new workbook it quit working.

Can someone help? Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread:
http://www.excelforum.com/showthread...hreadid=544476

Thanks Chip!! It works just fine now!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=544476