Compile Error: Method or data member not found

[DavidBAI]

Hi I'm a VBA novice, however recently an xlsm that I wrote some time ago now comes up with Compile Error: Method or data member not found and in the code it highlights in yellow the Private Sub Worksheet_Active(), and underneath in blue .ListboxSh within this line; Me.ListBoxSh.Clear.
This xlsm works fine on other machines, just not mine.
One bit of possible help to this is, I was trying to build a Power BI to access an onld Access Database and it wouldn't so I tried to install accessdatabaseengine_X64. Is it possible this is a clue?

 

[Tom Urtis]

Looks to me like the procedure should be
Worksheet_Activate()
which would go into the worksheet of interest's module.

 

[Michael M]

I don't have Excel atm, but if you post the offending code, someone may be able to help.