Repeat buttons

Hi everyone,

I've got this piece of VBA that seems to do what i want:

-------

Please Login or Register  to view this content.

----------

It creates a button on the h4 cells with a "fit to cell size", can i modify this code to have this button create not only on h4, but i want this button to be on cell h4 to h1000. So i need to modify this code to do some sort of copy paste on multiple cell.

If i modify the range to h4;h1000, it will create 1 cell the size of my request, but i need 1000 buttons in 1 code.

Any help on how to loop or modify a quantity?

thanks!

You could do something like this:

Please Login or Register  to view this content.

Regards

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Add the code tags before I lock the post

i've found something,

This code works

Please Login or Register  to view this content.

i remove the onaction, but now i can't click on it to make it change from coaching, to email sent, anyone can help reintegrate the onaction so it change name when i click on it?

.OnAction determines the *macro* that is run when the button is clicked. Of of the things that macro could do is to change the caption.

I rather assumed that you had the rest of the code to go with the button you've(s) created.

The error comes from the fact that you have/had a space in the text.

Change it to: .OnAction = "eMailSent"

But, as stated above, you need a macro called "eMailSent" to send the email (?) and change the caption.

Regards