|
Calendar
How do I get a text box to be a date box on a form?
|
Calendar
Hi krc547
Maybe this page will help http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "krc547" wrote in message ... How do I get a text box to be a date box on a form? |
Calendar
How do I get this on a form? I went to the link and it stated how to put it
in an excel spreadsheet. "Ron de Bruin" wrote: Hi krc547 Maybe this page will help http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "krc547" wrote in message ... How do I get a text box to be a date box on a form? |
Calendar
Scroll down to bottom of page where it says "More Information" and
"See also this page if you want the Calendar control on a user form." Click the link. Gord Dibben MS Excel MVP On Tue, 27 Nov 2007 14:23:02 -0800, krc547 wrote: How do I get this on a form? I went to the link and it stated how to put it in an excel spreadsheet. "Ron de Bruin" wrote: Hi krc547 Maybe this page will help http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "krc547" wrote in message ... How do I get a text box to be a date box on a form? |
Calendar
Ididn't want anything that big, is there a way to make it smaller?
"Gord Dibben" wrote: Scroll down to bottom of page where it says "More Information" and "See also this page if you want the Calendar control on a user form." Click the link. Gord Dibben MS Excel MVP On Tue, 27 Nov 2007 14:23:02 -0800, krc547 wrote: How do I get this on a form? I went to the link and it stated how to put it in an excel spreadsheet. "Ron de Bruin" wrote: Hi krc547 Maybe this page will help http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "krc547" wrote in message ... How do I get a text box to be a date box on a form? |
Calendar
Not unless you want to lose some of the form.
ViewProperties Window and play with Height and Width and PictureSizeMode. You may squeeze it a tiny bit smaller. It is only 150 pixels by 150 pixels so how much smaller would you want? Gord On Tue, 27 Nov 2007 15:05:04 -0800, krc547 wrote: Ididn't want anything that big, is there a way to make it smaller? "Gord Dibben" wrote: Scroll down to bottom of page where it says "More Information" and "See also this page if you want the Calendar control on a user form." Click the link. Gord Dibben MS Excel MVP On Tue, 27 Nov 2007 14:23:02 -0800, krc547 wrote: How do I get this on a form? I went to the link and it stated how to put it in an excel spreadsheet. "Ron de Bruin" wrote: Hi krc547 Maybe this page will help http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "krc547" wrote in message ... How do I get a text box to be a date box on a form? |
Calendar
My form is pretty big but when I selected the calendar from the tool box, it
showed up as 1/3 of my form, when I try to resize it, you can not see the dates. "Gord Dibben" wrote: Not unless you want to lose some of the form. ViewProperties Window and play with Height and Width and PictureSizeMode. You may squeeze it a tiny bit smaller. It is only 150 pixels by 150 pixels so how much smaller would you want? Gord On Tue, 27 Nov 2007 15:05:04 -0800, krc547 wrote: Ididn't want anything that big, is there a way to make it smaller? "Gord Dibben" wrote: Scroll down to bottom of page where it says "More Information" and "See also this page if you want the Calendar control on a user form." Click the link. Gord Dibben MS Excel MVP On Tue, 27 Nov 2007 14:23:02 -0800, krc547 wrote: How do I get this on a form? I went to the link and it stated how to put it in an excel spreadsheet. "Ron de Bruin" wrote: Hi krc547 Maybe this page will help http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "krc547" wrote in message ... How do I get a text box to be a date box on a form? |
| All times are GMT +1. The time now is 09:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com