ActiveX Control Spin Button Copy Button and Change Cell reference?

Hello everyone.

I am attempting to create an ActiveX script button forgive me I am a newbie, and I hope my question makes sense. The main reason I am using ActiveX as opposed to form control. I shared this spreadsheet few people and they could not download a file with form controls. I managed to make the button, but I cannot seem to figure out how to copy and paste and change the cell reference. I could manually do all 189 cells but if there is a easier way. I would love learn it. If anyone can assist me. It would be appreciated. Thanks


I would like to copy this button to cells D2:D64, C2:C64, and E2:E64 if it is possible

Please Login or Register  to view this content.

In addition, I recorded a macro of me copying the button in hopes maybe I could see something in the code to help me solve my dilemma. This is the code it generated maybe this can help with ideas.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Hi, welcome to the forum.
I would like to help but I do not really grasp what you're trying to achieve.
The thing about users not wanting Form controls, well, that sounds rather odd to me, but, who am I to judge
Is it possible that you attach a simple file with the vba code you have?
I am assuming that you want a spin button next to each cell form row 2 though row 64 for each of the three columns?
I think you'll run into issues with tha max number of controls on a worksheet, but I'm not sure of that.
It's also quite handy if you tell us which version of Excel you're using. Not all of us have the same version.