Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two values in a combobox alvin Kuiper Excel Programming 2 February 23rd 06 06:55 PM
Format & formula retained Ray Excel Worksheet Functions 1 December 12th 05 03:39 PM
Fill values into a listbox matching selected values from a combobox Jon[_19_] Excel Programming 4 January 25th 05 04:25 PM
ComboBox Values Jim Berglund Excel Programming 4 August 17th 04 10:18 PM
ComboBox Values Darren[_3_] Excel Programming 1 July 16th 03 10:41 AM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"