Filling a combo box with code 1

[Syerston]

If you are creating a list for a combo box in VBA what should the syntax be.

If PassId = "99" Then
   cboSelect_RAD.Value = "301"
End If

This works for one value, but how then do you give it a list.


John

 

[tomschafer]

You have to set the RowSource property of the combo box and add semi-colons between values. Also make sure that the RowSourceType of the combo box is set to value list. i.e.

If PassId = "99" Then
cboSelect_RAD.RowSource = "301;302;303;304"
End If

 

[Syerston]

Works a treat!!!

Many Thanks John