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...