COMBOBOX VALUES NOT BEING RETAINED
 

I have a custom (Excel) UserForm setup with, among other things, a
ComboBox.
This ComboBox is referencing a range (A2:B24) on the spreadsheet, with
the second column bound. Here are my columns:

A B
3100 0.032
3200 0.032
4100 0.04
4200 0.04
4300 0.04
5100 0.05
5200 0.05
5400 0.05
5700 0.05
5800 0.05
6100 0.062
6300 0.062
6400 0.062
7100 0.07
7200 0.07
8100 0.08
8200 0.08
8300 0.08
8400 0.08
9100 0.09
9400 0.09
9500 0.09
9600 0.09


When I select a value of "3100" in my Combobox, the Combobox
displays "3100" and properly returns a value of "0.032" to the
appropriate cell on my spreadsheet; just as it should. However, when I
select "3200", the Combobox always "rolls" back to display
"3100" on the very next click event (regardless of which UserForm
object I click next). This is only happening with the "A" column
values that have a corresponding 3 (significant) decimal place value in

column "B". That is, "3200" rolls back to display "3100",
"6300" & "6400" both roll back to display "6100". The only
distinction I can see is the decimal values in the "B" column. If I
change the values from 0.032 to 0.030 & 0.062 to 0.060, everything
works fine, as do all of the other values in column "A" with 2
significant decimal places. How can I retain the proper value in the
ComboBox? Otherwise, does anyone know a workaround? Thanks in advance.
Paul

COMBOBOX VALUES NOT BEING RETAINED
 

Well, I created a new ComboBox and populated it with the identical data
that I had in my original ComboBox, except I copied the data range to a
new location on the WorkSheet. As you might expect everything worked
fine! I changed the format of Column "B" to "text" instead of custom
"#.###" and viola! Strange but true. Paul