Select date userform based on Userform selection

**Excelnoub** · 04-05-2014, 03:33 PM

Good day,
I am working with DatePicker calendar. I have two userform with date entries. In one userform I will have 2 textbox to enter dates. In the other one I will have 4 dates to enter. I used to have Excel 2007 with Calendar Control and used to work fine but had to make multiple calendar to control individual Textbox in multiple Userforms.

I am looking for a way to, If a userform is selected to trigger only the textbox name that is within that userform. If I add more entries the code adds automatically the date from the previous userform in the next one.

This is what I have in my Userform Calendar (Datepicker):

Please Login or Register  to view this content.

I was thinking that this would work but it still adds the date to my frmdashboard userform if I am in my frmdata userform.

Is there a way to trigger only the userform that I am currently in?

Using Excel 2013.

Note: I also have a "Clear All" VB Code that will delete every entry in my userform on Initiate but I am looking to not go this path.

Thank you,

Excel Noub

**Excelnoub** · 04-05-2014, 03:41 PM

Or is there just a better solution to have only one DatePicker to control any Textbox that I will have to input dates in any userform that would require this?

Trying to have the best solution.

**Excelnoub** · 04-05-2014, 08:47 PM

My question should be, how to make my date picker to populate multiple textboxes in multiple userform?

**Excelnoub** · 04-06-2014, 07:43 PM

Here would be an example of worksheet:

Userformdateentry.xlsm

Here would be an example:

If you click on the Command_Button in Sheet1 you will see the Userform... I need to indivually control all Textbox for date entry using one MonthView, with one monthview userform.

I need this for individual Textboxes in my frmdate userform. When I click on a textbox, and when the calendar is called, to insert the date selected. But every text box must be controlled individually.

**Excelnoub** · 04-07-2014, 09:47 AM

Here is my solution:

In a Module:

Please Login or Register  to view this content.

in the monthview calendar (mine is named frmCalendar2)

Please Login or Register  to view this content.

In my Userform that will call the Monthview to add to my textbox:

Please Login or Register  to view this content.

Provided by Chandoo ... NARAYANK991

If this can help anyone in the future

**gabrifernandez** · 04-07-2014, 10:45 AM

Am using Excel 2010. I wanted to create a userform in excel, a date & time (both to be obtained in a single cell), based on this selection a target date shall be selected with if formula in another column.

And the users may have different versions from 2003 to 2013, is it possible to provide a date & time picker

Select date userform based on Userform selection

LinkBack

Thread Tools

Rate This Thread

Display

Select date userform based on Userform selection

Re: Select date userform based on Userform selection

Re: Select date userform based on Userform selection

Re: Select date userform based on Userform selection

Re: Select date userform based on Userform selection

Re: Select date userform based on Userform selection

Thread Information

Users Browsing this Thread

Similar Threads

How to put into userform that can select number of page to print using userform?

Selecting which userform to use based on cell selection

Populating a userform based on a combobox selection

Populating a userform based on a listbox selection

Select sheet based on userform date input

Bookmarks

Bookmarks

Posting Permissions