Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ComboBox with 3 decimal places, Please Help!
I've created a ComboBox on a UserForm and would like it to display a 3
place decimal (3 significant places), how/where do add code to do this? I'm just pulling the values from my worksheet for the user to select an optional size. I think (hope) this might be the solution to the "rolling Combobox" problem I'm having; see this post: http://groups.google.com/group/micro...c1669166f74ac5 I sure would appreciate some advice! (...my boss is getting a little impatient by now!) Thanks, Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ComboBox with 3 decimal places, Please Help!
Hello
If you are pulling your values from a worksheet, you may consider this: With Worksheets("Sheet1") For i = 1 To .Range("A65536").End(xlUp).Row Me.ComboBox1.AddItem (Format(.Cells(i, 1), "0.000")) Next i End With HTH Cordially Pascal |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ComboBox with 3 decimal places, Please Help!
Thanks Pascal,
Since I'm not really a VBA wizard (...nor do I play one on TV), could you please tell me exactly where I might insert this code? Paul |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ComboBox with 3 decimal places, Please Help!
Paul
You may also consider amending the sample code I supplied with 1- the relevant sheet name 2- and the range where your data stands (in my sample code sheet name is Sheet1 and Data starts from range A1 downwards) HTH Cordially Pascal |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ComboBox with 3 decimal places, Please Help!
Can't see my previous post?
So here it is again: Hello Paul You may put the code in the Userform_Initialize event HTH Cordially Pascal |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ComboBox with 3 decimal places, Please Help!
Thanks Pascal,
I'm putting out another fire at the moment, I should try out the code early this afternoon. I'll keep you posted. Paul |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ComboBox with 3 decimal places, Please Help!
Yep, that did the trick for the decimal places. Thanks.
Now, do you have ANY idea why my ComboBox won't retain my selection (this is from the post that I refer to above)? Paul |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create ComboBox with 3 decimal places, Please Help!
Pascal,
I fixed the problem that I was having with the ComboBox "rolling" as described in post linked above. Thanks for your help. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Places | Excel Worksheet Functions | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
decimal places | Excel Discussion (Misc queries) | |||
Create a marcro that changes number of decimal places in a field according to specified criteria | Excel Programming |