ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   COMBOBOX VALUES NOT BEING RETAINED (https://www.excelbanter.com/excel-programming/356363-combobox-values-not-being-retained.html)

[email protected]

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



All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com