Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box
I accidently posted this in the general section and then decided it was a
programming question. Here it is: 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box
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: I accidently posted this in the general section and then decided it was a programming question. Here it is: 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 | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
In Excel I need to set up a combo box based on another combo box. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |