Home |
Search |
Today's Posts |
#1
|
|||
|
|||
combo box formatting
In a column2 on my sheet1 I have dates with the following format: mm/dd/yy.
I have a userform that pops up and the user is to select a date from the drop down box. The drop down ties back to the unique entries in column2 on sheet1. When the date is selected, the code is supposed to autofilter sheet1 to the value in column2 that the user selected from the combo box. This isn't working! If I try the same techniqe with columns that have text only, all works fine. It just don't work on the date comumn. I am sure it has to do with the format on the combo box. How can I format the combo box to mm/dd/yy? |
#2
|
|||
|
|||
Sometimes, if you work with the values, you get better results.
kind of like: myrng.AutoFilter Field:=1, Criteria1:="" & clng(cdate(combobox1.value)) scrabtree23 wrote: In a column2 on my sheet1 I have dates with the following format: mm/dd/yy. I have a userform that pops up and the user is to select a date from the drop down box. The drop down ties back to the unique entries in column2 on sheet1. When the date is selected, the code is supposed to autofilter sheet1 to the value in column2 that the user selected from the combo box. This isn't working! If I try the same techniqe with columns that have text only, all works fine. It just don't work on the date comumn. I am sure it has to do with the format on the combo box. How can I format the combo box to mm/dd/yy? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Formatting sheets | Excel Discussion (Misc queries) | |||
Linking Combo box to pivot table? | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |