Create Command Button

Hello:

Please refer to attached file.
I have store names in Column B as shown.
I need Vb code to create command button in cell C3,C4 and C5 so that if i press any of the button then it will
give cell D1 the name of the correspoding store name.
Example:

If I press the button in Cell C3 then D1 = Store1
If I press the button in Cell C4 then D1 = Store2
If I press the button in Cell C5 then D1 = Store3

Let me know if you have any questions.
Thanks.
RM

Hi rizmomin, here's a quick alternative using Buttons (Form Control) and linking them to one (public) Macro:

Please Login or Register  to view this content.

See if that works for you.

Cheers,
berlan

Hi Guys:

Both solution seems to work great, howver i will use Berlan as it creates the button also.
Thanks a bunch to both, i will further test and let you know if any problem.
RM

Hi Berlan or Trebor:

Is it possible to name the buttons created in column the same as the names from Column B.
Example Cell B3 is Store1 so the button created in cell c3 need a name as Store1 and so on.
Please let me know if you have any questions.
Thanks.

RM

Hi Trrbor:

Superb,.....Love it....Works great.
May i ask one last thing.
When i run "Sub CreateButtons" and run CreateButton again it creates layer of Buttons.
Is there a way to code so that when i run Sub CreatButton, it deletes old buttons and create new one.
This is not a biog issue but wonder why this is happening.
Please let me know if you have any questions.
Thanks.

RM

Hi Trebor:

Sorry to bother you.
Please refer to attached file.
I tried to create another column of buttons and this time wanted the output to go to Cell E1
So basically, any button presses in column C needs to go to Cell D1 &
any button presses in column D needs to go to Cell E1
i tried but it is still going to cell C1 only.
Let me know if you have any questions.
Thanks.

Hi Trebor:

It seems to work now, not sure what i was doing wrong.
But i really appreciate all the help i am getting and learning a lot from expert like you.
I just want to say that i am not a programmer but i am able to adopt the code with my logic and help from this forum.
Thanks a lot and will contact you further if needed.
RM

Glad it worked -- and great modifications Robert!!!

Could also compare with the topleftcelladdress in the DelButton script:

Please Login or Register  to view this content.

Cheers,
Johan

Hi Berlan and Trebor:

Thanks a lot to come up with great solution for me and some others i am sure are looking into this important tool to create Macro Buttons
RM