This shouldn't be too hard. Although I've never personally used .RowSource, the following ought to be more or less equivalent:
[vba]ComboBox1.RowSource = ActiveSheet.Range("B3:B7")[/vba]
[vba]ComboBox1.List = ActiveSheet.Range("B3:B7")[/vba]
This shouldn't be too hard. Although I've never personally used .RowSource, the following ought to be more or less equivalent:
[vba]ComboBox1.RowSource = ActiveSheet.Range("B3:B7")[/vba]
[vba]ComboBox1.List = ActiveSheet.Range("B3:B7")[/vba]
Posting Permissions
Reply With Quote