Copy cell contents to Button Label?

Hello all,

I have several buttons, created from the Forms Toolbar. Is it possible to pull the contents (Text) from different cells, to the Buttons as part of the Label on each button?

Thanks,

Dean

Hello Dean England,

Here's the code...

Please Login or Register  to view this content.

To use it...
This example adds the contents of cell D5 to the label of the Button named "Button 1".

AddCellToButtonLabel $D5, "Button 1"

Sincerely,
Leith Ross

Hi Leith,

I've tried your code several ways and I can't seem to get my head around this thing. I think I'm having a bad week today. I don't know what I'm doing wrong, but....... Maybe you could explain it to me like you would a small child.

I've attached an example of the worksheet.

Thanks for looking.

See ya,

Dean

Hello Dean,

I got it working. I didn't know you wanted to dynamically change the button's caption based on the contents of changing cell. Here is the macro, and I already added it to your workbook.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hey Leith Ross,

Thanks a lot. You didn't know I wanted it dynamically, because I forgot to mention that small major detail . Seems to happen a lot with me, in my advancing years. Many Thanks and have a good day.

See ya,

Dean