ComboBox Value

[Braxy]

I have a Combobox on a form and would like the Combobox to show only the min value from the data in the spreadsheet. The code listed below list all the data from the spreadsheet but as stated, I would like it to list only the min value from the list.
Any help would be appreciated.


Private Sub UserForm_Initialize()



ComboBox19.List = Sheets("Medal Score").Range("B9:B1000").Value

End Sub

 

[Jerry Sullivan]

Try...

Private Sub UserForm_Initialize()

 ComboBox19.List = Array(Application.Min( _
   Sheets("Medal Score").Range("B9:B1000")))

 End Sub

 

[Braxy]

Jerry,
Thanks for your help, the code you supplied works great.