Happy Saturday all,
I have bumped in an issue of finding a solution how to allow user to change default combobox value. Some details:
Combobox is on a userform
Combobox is in date formatCombobox style is set to fmStyleDropDownCombo and MatchRequired to False
Please Login or Register to view this content.
RowSource is linked to DATA!H2
Basically I want to allow user to change the default combobox value when required.
What am missing here?
Thanks for your time!
This will set the combobox value to the date in cell H2 if that's what you are asking.
ComboBox1.Value = Format(Sheets("DATA").Range("H2").Value, "dd/mm/yyyy")
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi AlphaFrog and thanks for a speedy response.
As I mentioned above combobox is already populated with the date from H2 using RowSource property.
The problem is I cannot get to change this value in a combobox should I decide to enter a different date from the one in H2.
Enter a different date where? Where are you entering a new default date?
H2 is = TODAY()
This is the date that is set as default in a combobox. Majority of transactions will be made on today's date, but there are occasions when we fall behind with transactions and need to key in some backdated transactions.
Therefore, user loads the userform, today's date appears in a combobox, but user needs to be able to change today's date to any other date.
How do you want them to change that date?
They could simply type in a new date in the combobox.
That is the problem that I cannot change it. It lets me delete the combobox default date, but when I start typing, combobox populates with 31/12/1899.
Now we're getting to the problem.
If you have any Combobox1_??? procedures, can you post all of that code?
One finding - I have disabled formatting of a combobox and it lets me input any value, but I need to format it as date, otherwise combobox populates with general format 42287.
No, there are no other procedures other than macro grabs whatever date is in a combobox and places it in a cell in a database.
Please Login or Register to view this content.
Why are you using a Combobox instead of just a Textbox?Please Login or Register to view this content.
Spot on! A million thanks mate!
You're welcome.
Hi there,
Take a look at the attached workbook and see if it's of use to you.
It places today's date in a TextBox on a UserForm, allows you to edit the date if required, and generates an error message if an invalid date is entered.
Hope this helps - please let me know how you get on.
Regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks