Hi forummates,
Following code works...
Following code doesnt work...Private Sub Worksheet_Activate() Sheets("Sheet1").ComboBox1.List = Sheets("Sheet1").Range("A1:A3").Value End Sub
Do you know why?Private Sub Worksheet_Activate() Sheets("Sheet1").ComboBox1.List = Sheets("Sheet1").Range("A1:C1").Value End Sub
Enclosed file for testing...
Bookmarks