LDDate on Userform

[pezalmendra]

Hello!

Does someone knows how can I link a cell in my workbook to a "LDDate" in my userform? What I'm really looking to is to each time I open the userform, look in the range B1:B500 for the maximum value and display it on the LDDate box I have on my userform.

Before I was using this with the following macro but this only works for a textbox...

Please Login or Register  to view this content.

Thanks!

[Richard Buttrey]

Hi,

What sort of object is your 'LDDate' in the user form. A ComboBox, ListBox or what. Whatever it is just change the reference to 'TextBox1' to whatever.

[pezalmendra]

It's a date format in which you select from a small calendar the day you want to input. I tried changing the reference of Textbox but maybe Im not putting the correct name...

[Richard Buttrey]

Hi,

But what's the object? If it's the old msCal (Calendar) object then use the objects name - presumably 'Calendar1' instead of 'Textbox1'.

And If it is the old msCal calendar object are you sure the maximum cell in B1:B500 is a valid date that the calendar can recognise?

[pezalmendra]

Hi,

I dont really know if its the old calendar or not but I'm now wondery if maybe the main proble is that the calendar doesnt recognise the format of the cells in range B1:B500

[royUK]

Attach an example workbook

[pezalmendra]

Hello and thanks for your interest!

I have attached the Excel book in which Im working on. The idea is that when executing the macro (the command buton on the top left hand side "Run") on the first UserForm that pops up the date and time that appears displays the maximum value from range I13:I1012 and J13:J1012 respectively.

Hope you can help me!!

Thanks!!

[royUK]

You have used ActiveX Calendar controls. These are problematic becaause they are not available to all users, I am using Excel 2010 which no longer supports them

[pezalmendra]

Ok thats good to know cause It opens a message alert each time I try to run the userform... Is there any other I can use instead and I will change it better...

Thanks!

[Richard Buttrey]

What exactly do you want to do with the maximum date when you get it.
Is it just for information on the UserForm, in which case you could simply populate a label or textbox control with the date. Or do you want the user to be able to change the date and then do something with it?

[pezalmendra]

Well theorically its just for information only but I would like to leave it open so that the user can modify if necesary

Thanks

[Richard Buttrey]

Hi,

I don't understand. Those two choices are mutually exclusive. It can't be both 'for information only' and for 'modification if necessary'.

If you want to be able to modify it and use the date in your macros then you can either
1. Read it into a ComboBox which the user may or may not change.
2. Open an InputBox which shows the user the date and prompts the user to change if necessary
3. Read it into say a label or TextBox and provide say three list boxes from which the user can choose a day, month and year, (in a similar way to what you see on web forms which ask for say DOB)

1 & 2 are similar and you'll need to write some additional code to validate what the user enters to ensure it's a proper date that a macro could use.
3 is simpler since it forces the user to use only valid numbers from which a Date Serial number can be constructed.

[royUK]

Use one of my solutions here at the bottom of the datePicker section.

[pezalmendra]

Hello and thanks for the help!!

I found on the web an excel sheet where there is a "date input" field really nice and that I think can be usefull. When clicking the field it pops up a calendar where you can choose the date.

You will find it doing:

- Open workbook
- Run the macro on the doing click on "RUN" botton.
- On the userform click the field that says "6-FECHA INGRESO:"

The only thing I cannot manage to do is to take that calendar to my own excel. Its strange cause when opening the userform in the VBA I cannot see that field!!

Hope you can help me!

Thanks!