ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Enter date in userform using Calendar Control (https://www.excelbanter.com/excel-discussion-misc-queries/222901-enter-date-userform-using-calendar-control.html)

Scotty9349

Enter date in userform using Calendar Control
 
I am trying to fill in a userform textbox with a date the user selects out of
a pop-up calendar. I have the pop-up calendar created using the Calendar
Control feature. Also I am able to push the date to a cell, but I would like
the date to populate in the userform as a form of feedback.

Also I need the user to enter two different dates using the pop-up calendar.

I have been trying to pass the data usign a variable, but am unable to get
that to work.

Any insight would be greately appreciated.

Scott


Scotty9349

Enter date in userform using Calendar Control
 
Figured it out. Ended up using a "Public blnNum As Boolean".

"Scotty9349" wrote:

I am trying to fill in a userform textbox with a date the user selects out of
a pop-up calendar. I have the pop-up calendar created using the Calendar
Control feature. Also I am able to push the date to a cell, but I would like
the date to populate in the userform as a form of feedback.

Also I need the user to enter two different dates using the pop-up calendar.

I have been trying to pass the data usign a variable, but am unable to get
that to work.

Any insight would be greately appreciated.

Scott



All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com