VBA code takes long to excute

[asher_nk]

Hi all,

I am very new to VBA. I would like my code add a comment box to the active cell based on the text in the active cell. As the user inputs code it should add a comment. However when users move down the sheet and populate the rows it seems that the code takes longer to execute. Any help would be much appreciated.

Thanks.

 

[asher_nk]

Hi Michael,

I think i have solved why my code takes too long to run. Due to the VBA line regarding auto sizing. Everytime the code runs its resizes all the comment boxes.

Dim xcomment As Comment
For Each xcomment In Application.ActiveSheet.Comments
xcomment.Shape.TextFrame.AutoSize = True
Next

End Sub

So I changed the code to this instead:

ActiveCell.Comment.Shape.TextFrame.AutoSize = True

My apologies for not using the code tags still learning the lingo. Thanks for your help.

 

[Michael M]

Did you try the modified code in Post #10

My apologies for not using the code tags still learning the lingo.

No worries ...glad to help !!..

 

[asher_nk]

Hi Michael,

I did and it works as well. Thanks again