Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COMBOBOX VALUES NOT BEING RETAINED | Excel Programming | |||
Two values in a combobox | Excel Programming | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
ComboBox Values | Excel Programming | |||
ComboBox Values | Excel Programming |