Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox properties---need to recognize comma's in numgers
Can anyone tell me how to make a combobox recognize comma's within number
strings. I have the linkedcells formatted as numbers and currency but the display of the combobox will not show the comma's making large numbers hard to read. Thank you in advance for your help. Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox properties---need to recognize comma's in numgers
This can be done using Format, as in:
ComboBox1.AddItem Format(Range("A1"), "#,##0.00") or something to that effect. HTH "Ed P" wrote in message ... Can anyone tell me how to make a combobox recognize comma's within number strings. I have the linkedcells formatted as numbers and currency but the display of the combobox will not show the comma's making large numbers hard to read. Thank you in advance for your help. Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox properties---need to recognize comma's in numgers
Ed,
How are you loading the combobox. Try loading the text value, such as With Me.Combobox1 .Additem Activesheet.Range("A1").Text 'etc End WIth -- HTH RP (remove nothere from the email address if mailing direct) "Ed P" wrote in message ... Can anyone tell me how to make a combobox recognize comma's within number strings. I have the linkedcells formatted as numbers and currency but the display of the combobox will not show the comma's making large numbers hard to read. Thank you in advance for your help. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace Comma's with Dash | Excel Worksheet Functions | |||
Viewing combobox properties | Excel Discussion (Misc queries) | |||
TextColumn Properties of ComboBox | Excel Discussion (Misc queries) | |||
Setting properties to combobox | Excel Programming | |||
ComboBox ProperTies | Excel Programming |