"combo box- numeric characters"

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

Guest

How do you get the final displayed number in a control combo box to have the
same format as the list fill range numbers?
 
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
 
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

Combo Box Help 3
Combo box result text not number 2
MS Access problem 0
Excel combo box edit 1
Link cell to combo box 2
Combo Box 1
Combo Box Formatting 4
How do I create dependent combo-boxes? 3

Back
Top