Shapes.Range(Array("OptionButton1")).Select ![]() ![]() For it to work, I have to split it up, and introduce a Select command. The above works whether or not Sheet1 is the ActiveSheet, and whether or not OptionButton1 is in a column that is currently hidden. In Excel for Windows, here's how I change the text: ThisWorkbook.Sheets("Sheet1").Shapes("OptionButton1"). = "New Text" (Based on some input, the text of the Option Buttons needs to change.) One bit that is really confusing me is changing the text of some Option Buttons that I have on a few different sheets. ![]() (I have Office 365, so I have the most current versions of Excel on both computers.) For the most part it works fine, but there are a few things that aren't working. I have made a workbook on Excel for Windows and I am now trying to get it to work on Excel for Mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |