Forum Discussion
compile error method or data member not found
Hi, Using my work computer to open a macro enabled worksheet and im unable to type. i have not changed anything or touched anything and i am a total noob when it comes to stuff like this. This is...
xWs.OLEObjects("TempCombo") refers to an ActiveX combo box named TempCombo.
On the Home tab of the ribbon, in the Editing group, select Find & Select > Selection Pane.
You should see a task pane on the right hand side of the window that lists all objects (shapes) on the worksheet. Do you see TempCombo in this pane?
That means that there is no combo box named TempCombo on the active sheet, hence the error message. Perhaps the code was intended to be run from another sheet?