Microsoft Office Forums - View Single Post - [Solved] Use VBA to resize a note entry

Thread: [Solved] Use VBA to resize a note entry

View Single Post

Old

12-20-2021, 12:04 PM

trevorc

trevorc is offline

trevorc uses Windows 7 32bit

Windows 7 32bit trevorc uses Office 2013

trevorc uses Office 2013

Office 2013

Competent Performer

The original poster

Join Date: Jan 2017

Posts: 173

trevorc will become famous soon enough

trevorc will become famous soon enough

Default

With a lot of trial and many errors i found this works.

Code:

    Intersect(ActiveCell.EntireRow, tblColumns("Notes").Range).Comment.Shape.Width = 600
    Intersect(ActiveCell.EntireRow, tblColumns("Notes").Range).Comment.Shape.Height = 800

Reply With Quote