Paste contents of a random cell to a callout

[Marie1uk]

Hi,

My VBA is very limited so I hope others with more experience can assist.

I am looking for a macro that will copy the text-based contents of a random cell in the range B100:B135 to a callout text box. The name of the callout is Autoshape 13. The callout should be cleared before pasting the contents of the next random cell into it. This macro will be assigned to a button.

Thanks in advance.

-Upside

[mudraker]

Try this macro

Please Login or Register  to view this content.

[Marie1uk]

Thanks for your input Mudraker. At first it didn't work (nothing happened) but after glancing through the code I noticed there was a typo on the Autoshape number (you missed the 1 off 13). After I added the 1 it worked great - thanks a lot, I really appreciate it!

In my quest to become more adept at Vba would you mind explaining what the "b" does in the line above the end with line? I don't see b defined anywhere.

[mudraker]

When I was testing the code I was using Autoshape number 3

Sorry about overlooking changing the 3 to 13

Glad to hear about from that error it works for you