user form with Calendar - txt box not Cell

[David0079]

Hey all,

I've been scouring the internet trying to find a solution to this one and I keep hitting a wall. I have a userform and I would like people to be able to click on a txtbox and a calendar pop up. they select a date, hit ok and it populates the txt box with that date. I have made the calendar form and I am able to get it to appear but how do I get it to put the date back into the txtbox? There are multiple date txtboxes on the sheet and I need to populate each one individually as you click on them. All of the methods I have found so far are about populating a field in excel Any help anyone?Dave

 

[Norie]

Dave

Are you using a control for the calendar?

If so which one?

 

[David0079]

What do you mean when you say control? I'm using Excel and the information will back into a sheet.

 

[Norie]

Dave

You say you've got a userform?

Well what controls are on it? eg textbox, calendar, datepicker etc

 

[David0079]

Oh sorry m8, I have 8 text boxes at the moment, 4 on one side and four next to them on the other. People using the form will enter an event on the left and a date on the right but I would like a calendar to avoid people entering dates in wrong format etc. I have created the calendar in another form. At the moment I'm not sure wether how to activate the date form, can you open a form buy clicking in a text box and of course the problem of getting the date back into the textbox.

Dave

 

[Norie]

Dave

I think you might be overcomplicating things by using another form for the calendar.

I understand your concern about checking the data entered, but that can easily be done using other methods. eg IsDate

And if the date is required in a particular format again that can be done.

Also there are actual controls available for entering dates/times, they are available when you goto Tools>Additional Controls...

 

[David0079]

I just found the Date Picker, God Bless you!

 

[Norie]

Dave

Glad to help.

One caveat though, the datepicker control isn't a 'standard' control.

So if what you are doing is going to be distributed then you may encounter problems if other users don't have access to it.

 

[David0079]

Norie, If someone doesnt enter a date in the date picker it keeps todays date which is then entered onto the spreadsheet. Is there a way for this to display nothing unless a date is picked? Thanks

 

[Norie]

Dave

I don't think you can really say that a user enters a date into the datepicker.

They choose a date, and if they don't choose one then it returns a default. eg today's date.

How exactly are you using the controls?