ComboBox properties---need to recognize comma's in numgers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
This can be done using Format, as in:

ComboBox1.AddItem Format(Range("A1"), "#,##0.00")

or something to that effect.

HTH
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox filtering 2
Add Values in a comma separated cell to combobox 2
Combobox selection 1
Worksheets, comboboxes, and integer values 1
ComboBox Format Problem 1
Rename combobox with a macro 1
Change properties of a combobox with VBA 0
Userform ComboBox Row Source 1

Back
Top