TextFrame.MarginBottom = 0 ' Margins Need To Be TweakedįoundRow = Cells.Find(What:='Fluid Driver', After:=Cells(FoundRow, FoundColumn), LookAt:=xlWhole).Row With Cells(FoundRow, FoundColumn).Comment.Shape ' Size Branch TSU Wage Comment Cell Similarly, the following code generates the same 'TextFrame' error, but works to set the comment box dimensions found successfully in VBA MS Excel 2011 for Mac.
In MS Excel 2019 for Mac the same VBA code above generates the error: The following VBA code successfully sets the size of all comment boxes of MS Excel 2011 for Mac to fit the comment text of every cell with a comment.įor Each Commnt In ' Autosize all comment boxes on the sheet
