View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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