How do you add multiple comment boxes?

**slipit1** · 09-26-2007, 03:40 PM

hello,

This is a repost, I would like to add a comment boxe in multiple sheets (same cell) in a work book. Someone reccomended a macro but then my post was removed.

**Ikaabod** · 09-26-2007, 03:56 PM

Here's some code to do this in all worksheets in a workbook:

Please Login or Register  to view this content.

**VBA Noob** · 09-26-2007, 04:06 PM

Slight mod to Ikaabod code.

His code will error after running once. Mod code won't

Please Login or Register  to view this content.

VBA Noob

**slipit1** · 09-26-2007, 04:34 PM

Forgive my ignorance, should I create a macro and add this code?

**VBA Noob** · 09-26-2007, 04:37 PM

See link

http://www.contextures.com/xlvba01.html#Regular

VBA Noob

**slipit1** · 09-26-2007, 04:54 PM

While I understand I could have created a macro or follow the directions from the link, it house the scrpit in the same location.

The code that I copied is giving me a run-time error at this location:

Please Login or Register  to view this content.

Will I be able to run this from any worksheet and have the cell populate in all sheets?

thank you for your patience.

**VBA Noob** · 09-26-2007, 04:55 PM

Code is unwrapped again after a warning. Please wrap now or post will be removed

VBA Noob

**slipit1** · 09-26-2007, 05:09 PM

Is this what you mean? I wish you would have explained what you meant the 1st time... If so it was a guess.

**VBA Noob** · 09-26-2007, 05:11 PM

Thx for wrapping code.

VBA Noob

**Ikaabod** · 09-26-2007, 05:25 PM

Try this:

Please Login or Register  to view this content.

**VBA Noob** · 09-26-2007, 05:51 PM

Give this one a go

Please Login or Register  to view this content.

VBA Noob

**slipit1** · 09-27-2007, 07:52 AM

VB,

Not sure what change you made, but that did it. Thank you!!

**VBA Noob** · 09-27-2007, 09:26 AM

Was the sht referencing

Glad it helped

VBA Noob

How do you add multiple comment boxes?

LinkBack

Thread Tools

Display

How do you add multiple comment boxes?

Bingo!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions