I have an Excel spreadsheet with a lot of VBA programming in it, including several userforms. When I run it on a windows PC, the VBA code that changes the background color of command button works as expected; however, when I run the same spreadsheet on an iMac (using Office365 on Catalina OS), the code does not function, although it does NOT throw any errors, either.
Here’s a simple example of my VBA code attempting to set the color of a command button.
Me.cmdOK.BackColor = RGB(126, 219, 105) ‘light green
Fwiw, similar code works fine on a Mac with a Label control e.g.
Me.lblMyLabel.BackColor = RGB(126, 219, 105) ‘light green
Redshark is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.