[VBA] Show chart on userform problem

The View Chart button works perfectly for me. The userform comes up showing the chart, and clicking the option buttons changes the chart.

Please describe exactly what steps you take for the error to occur, and exactly what is the error number and error message.

You did not describe the steps for the error to occur.

My version is officially "Microsoft 365 Apps for Business". The version of Excels should match yours.

I click the button and the userform comes up. The error is actually occurring on this line, but VBA is hightlighting the call to Show. This is a drawback of VBA debugging mode. Sometimes the error line is flagged when a Sub is called, but the actual error is inside the Sub.

Please Login or Register  to view this content.

Unfortunately I still can't tell what the problem is. I don't see anything in your code that could cause that.

harrykim99.jpg