brent3162
New Member
- Joined
- Jul 13, 2024
- Messages
- 11
- Office Version
- 365
- Platform
- MacOS
Has anyone figured out how to get around this issue that seems to be specific to MacOS Excel 365?
When I'm in the visual basic editor, I select the sheet I want to monitor for a change, I attempt to select the "General" drop down selector, just above the code window and choose "Worksheet" so that I can enter the change event code but I get an error message. See attached
what I have is a customer name drop down list and when I select the customer from the customers worksheet, I want the automatically add the street address on next row below name and then city,state and zip on row below that. But cannot get to adding the code due to the error.
When I'm in the visual basic editor, I select the sheet I want to monitor for a change, I attempt to select the "General" drop down selector, just above the code window and choose "Worksheet" so that I can enter the change event code but I get an error message. See attached
what I have is a customer name drop down list and when I select the customer from the customers worksheet, I want the automatically add the street address on next row below name and then city,state and zip on row below that. But cannot get to adding the code due to the error.