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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two values in a combobox | Excel Programming | |||
Format & formula retained | Excel Worksheet Functions | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
ComboBox Values | Excel Programming | |||
ComboBox Values | Excel Programming |