How to put a button made through Control Toolbox

Hello again


I been trying to change the text of a button from Forms, in a protected sheet. I been reading that is better to work with Buttons of the Control Toolbox via VBA. But I dont know how to put a button of this kind in a sheet and make it look as a Forms button (i can only put buttons in User_Forms!!). Is this possible? Do i have to create a button via program? Any ideas on how to continue?

Thanks in advance for your help.

Joe

Good evening Joe

To make a button from the controls toolbox, open up the tool bar and click the Design Mode button (and that Joe, is the secret). Select a button and draw it wherever. To edit the text right click and select command button object > edit. To insert some code into it, double click on the button and it will open the click event code window linked to that button. When you are happy with it, click the design mode button again to make it into a button, that is linked to a piece of VBA code that can be clicked run a procedure.

HTH

DominicB

Thanks a lot Dominic for your prompt reponse,

I have few questions because i'm still confused, Hope you can keep helping me.

Let me try to tell you what i done so far:

1. First, Opened a new worksheet
2. Went to Visual Basic
3. Found the Design Mode button ( the one with a square ruler)
4. Here , I 'm stuck because i couldn't find a button to draw.
I needed to open a User_form in order to have access to the Tools wich contains the Controls (LABELS, TextBox, CommandButton, ComboBox, etc.)
So the button will be inside of a User_form.

Surely i misunderstood something and get lost in the your explanation. Could you give a hand to finally learn the way to produce buttons via VBA editor and be able to use their properties in a better way that in Excel Forms Toolbars

Thank you again

Regards

Joe

Originally Posted by dominicb

Good evening Joe

To make a button from the controls toolbox, open up the tool bar and click the Design Mode button (and that Joe, is the secret). Select a button and draw it wherever. To edit the text right click and select command button object > edit. To insert some code into it, double click on the button and it will open the click event code window linked to that button. When you are happy with it, click the design mode button again to make it into a button, that is linked to a piece of VBA code that can be clicked run a procedure.

HTH

DominicB

Dominic

After been confused, i read your reply again, and found i was searching in the VBA environment, when I should be looking in the Excel Menus!!!

The light has come!! THANKS AGAIN

Regards

Joe Louis

Originally Posted by jose luis

Thanks a lot Dominic for your prompt reponse,

I have few questions because i'm still confused, Hope you can keep helping me.

Let me try to tell you what i done so far:

1. First, Opened a new worksheet
2. Went to Visual Basic
3. Found the Design Mode button ( the one with a square ruler)
4. Here , I 'm stuck because i couldn't find a button to draw.
I needed to open a User_form in order to have access to the Tools wich contains the Controls (LABELS, TextBox, CommandButton, ComboBox, etc.)
So the button will be inside of a User_form.

Surely i misunderstood something and get lost in the your explanation. Could you give a hand to finally learn the way to produce buttons via VBA editor and be able to use their properties in a better way that in Excel Forms Toolbars

Thank you again

Regards

Joe

Hi Joe

No problem, glad to have helped, and thank you for the feedback.

DominicB