'worksheet events activation combo box content fill
Private Sub Worksheet_Activate ()
Me.Com boBox1. ColumnCount=1 'combo box for "1" column
Me.Com boBox1. ListFillRange="total inventory list! C2: c & amp; "" J 'the scope of the combo box="total inventory list". C column active area
Sheet1. Cells (I, 2). Select
End Sub
Prompt combobox1 methods and data members not found
The Me.Com boBox1 instead: Sheets (" turn out library table "). After ComboBox1

Private Sub Worksheet_Activate ()
Sheets (" turn out library table ".) ComboBox1. ColumnCount=1 'combo box for "1" column
Sheets (" turn out library table ".) ComboBox1. ListFillRange="total inventory list! C2: c & amp; "" J 'the scope of the combo box="total inventory list". C column active area
Sheet1. Cells (I, 2). Select
End Sub
Prompt combobox1 object does not support the properties and methods
Other computers running normally, my computer error code to run, if I installed the visual Basic after 2012, affected, please temporarily suspended

CodePudding user response:

Prompt combobox1 methods and data members not found

Refers to the which one didn't find?
Private Sub Worksheet_Activate ()
ComboBox1. ColumnCount=1
ComboBox1. ListFillRange="sheet2! C2: c4 "
End Sub
The above code in 2003 and 2007 are very normal

CodePudding user response:

Thank you for your help, I am using excel, until very normal, if after install the visual Basic 2010 errors, as long as there is ComboBox1 has certain error in the code, is really depressed,

CodePudding user response:

There are a lot of code, under the 03 with 10 different, such as shape, etc