VB Code to size the comment box

  • Thread starter Thread starter SUNIL PATEL
  • Start date Start date
S

SUNIL PATEL

After using :- Cells(1,1).Comment.Text Text:=discription$

where discription$="abcdefghijklmnopqrstuvwzyz"

Who do i resiz the comment box using code, such that the box will show the
complete comment.

I have tried to record a macro but this does not work.

Thanks
Sunil
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resize commentbox in VB 1
How to change comment Box width and high 2
copying cell comment from one sheet to another 2
Insert Comment in Current Call and set then width 1
Macro to copy cell contents to comment 2
Code to add comments to selected cells within a selected range 30
Code to add comment box 2
Error Trapping Issues 8

Back
Top