Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter...
Jim
1) Try using the Text property of the range to populate the combobox instead of the Value property. For a cell with 2.0 in it Text = 2.0 Value = 2 Remember that entries in a combobox are text regardless of what they are on the spreadsheet. 2) I don't know, but I seriously doubt it. I think you'll have to roll your own here. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "jim c." wrote in message ... i have a list box on a userform whose rowsource is a range on sheet1. i use comboboxes on a different userform(2) with code to add unique items from each column to each combobox.(basically just recreating autofilter on a userform) my problem is if range is formatted as number with 1 decimal place, and that number happens to be **.0 then only the whole number is added to the combobox and the filter code will fail because it is looking for say 2 as opposed to 2.0. question 2 would be if on the worksheet i select a range and apply autofilter i get the drop down arrows. one of the criteria is custom. is there a way i can use that "custom" dialog box as opposed to trying to write code to do same thing? thanks people... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |