I am in the process of adding command buttons to a worksheet but am having trouble changing a specific buttons properties correctly.
Sub RoundedRectangle3_Click basically decides where I will put a button.
The '& 1' at the end of those lines is how I decide which row to put the 5 buttons in.
From the same For-Next loop I call both of the functions that will create commandbuttons. This is when I start getting problems. I run the code in row 1 and the buttons are created perfectly except column 'C' which places 2 buttons on top of each other. (If you delete one button another is under it.)
The code in these functions is not my own which is why I don't fully understand but am hoping someone can explain what is going on.
After running the code in row 1 I attempt to run the code in row 2 or 3 and am able to do so but the font is wrong. (Not wingdings.)
Finally, every once in a while I will get an error:
'Object library invalid or contains references to object definitions that could not be found.'
If anyone can explain to me why the code does this I should be able to figure the rest out. I am still learning the syntax of VBA.
Thanks for any help.
EDIT: In the following line why does it have to be "Forms.CommandButton.1"
Bookmarks