Stuck in Excel 2007 Form Control Coding ( Command Button )

Asked By jessicafstout 0 points N/A Posted on - 04/28/2013

Hi Techy,

I've added a Command Button (Form Control) in an Excel Sheet. Since then I tried to write code under the Click method of this command button.

I don't know whether it's possible to add code under click method of Command Button (Form Control).

Any help will be highly appreciated.

Thanks 

Jessica

• Status: Open
• Question Views: 1009
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Software

Best Answer by Marvin M Calderon

Go To Solution

Best Answer

Best Answer

Answered By Marvin M Calderon 55 points N/A #139358

Stuck in Excel 2007 Form Control Coding ( Command Button )

Hello Jessicafstout,

If you want to add the code over the button then you need to follow some of the steps.

But if you are using any of the programming language then the code may vary from one language to the other.

You need to right click on the button after that you need to write the operation to be performed there in order to make it easy to use for the user.

But if you want to get more guide  and also you want to assign a macro to your button then you can get it from the link all you need is to follow some of the steps mentioned in the website.

 

About Marvin M Calderon

Questions
23

Answers
200

Best Answers
88

• Vote Up 0 Vote Down

• Posted on - 05/07/2013
• Question Category: Misc Software

Answered By Caldwell Llanos 5 points N/A #139359

Stuck in Excel 2007 Form Control Coding ( Command Button )

Hi Jessica,

Since you are working with excel so I assume that you are pertaining to adding macros to your Sheet.

I am a bit confused when you said “Since then I tried to write code under the Click method of this command button" versus “I don't know whether it's possible to add code under click method of Command Button (Form Control)”.

So I am guessing that the code you tried does not work?

You actually answered your question. Yes, you can write codes and to be specific these are VB codes.

Please check my attachment for a sample code.

About Caldwell Llanos

Questions
1

Answers
100

Best Answers
49

• Vote Up 0 Vote Down

• Posted on - 05/27/2013
• Question Category: Misc Software