If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"combo box- numeric characters"
How do you get the final displayed number in a control combo box to have the
same format as the list fill range numbers? |
#2
|
|||
|
|||
Maybe a bit of code.
Go into design mode (an icon on that control toolbox toolbar) and then double click on that combobox. Paste this into that window: Option Explicit Dim BlkProc As Boolean Private Sub ComboBox1_Change() If BlkProc = True Then Exit Sub With Me.ComboBox1 BlkProc = True .Value = Format(.Value, "##0.00000") BlkProc = False End With End Sub (Change the format to what you want to see.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm adam.ronalds wrote: How do you get the final displayed number in a control combo box to have the same format as the list fill range numbers? -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Keep quoted numeric characters as text. | Jay Waddoups | General Discussion | 2 | August 5th, 2004 04:00 AM |
Numeric field with math characters? | Casa | General Discussion | 8 | June 20th, 2004 04:33 PM |
Manipulate records of 2 tables | Praveen Manne | Using Forms | 11 | June 14th, 2004 02:41 PM |