Can't change button color in Mac Excel RRS feed

  • Question

  • Hello everyone,

    I am trying to use vba to change the forum button color when it is clicked. The code I wrote is as follow.

    "Sheet1.Shapes("Button 94").TextFrame.Characters.Font.ColorIndex = 1"

    The code works fine in Windows excel but not in mac. 

    The error message "Error 1004: The method "TextFrame" does not apply to object "Shapes".

    Does anyone know why it happens and how to solve it? Thanks!

    • Moved by Alex-KSGZ Friday, September 14, 2018 8:56 AM
    Wednesday, September 12, 2018 10:48 PM

All replies

  • Hi,

    According to your description, your issue is more related about VBA. And this forum is discussing and

    asking questions about the vb.net.

    Ask in the following forum.


    Thank you for participating in the forum activities.

    Best Regards,


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, September 13, 2018 1:48 AM
  • Hi Alex,

    Thank you for guiding me to the correct place! 

    Thursday, September 13, 2018 3:47 PM