vba code woks on a PC but not a MAC

[mhorstman]

Hi,

I'm looking for some help on why my code is working on a PC but won't work on a MAC. I have a sub that executes when the user uses the paste function to auto-format cells based on the data pasted in. I can't figure out why it won't work on a MAC. I thought it was because the control ID number was going to be different between the two OSs. I confirmed that it is 128 on both. Any help would be greatly appreciated.

Dim undolist As String
undolist = Application.CommandBars("Standard").FindControl(ID:=128).List(1)
If Left(undolist, 5) = "Paste" Then

The rest of the code after this is just the instructions for formatting.

 

[daimac64]

I've looked it up and I don't think this code works on a MAC. On the MAC, it looks like the object type cannot be retrieved correctly.

On PC
Debug.Print TypeName(Application.CommandBars("Standard").FindControl(ID:=128)) -> CommandBarComboBox
On Mac
Debug.Print TypeName(Application.CommandBars("Standard").FindControl(ID:=128)) -> CommandBarControl

On Mac, I don't think I can access the List object of a member of CommandBarComboBox.

 

[daimac64]

On Mac
Dim UndoList As CommandBarComboBox
Set UndoList = Application.CommandBars("Standard").FindControl(ID:=128)

-> UndoList is Nothing