Adding several CommandButtons to same worksheet.

[brentjohn]

Greetings,
I realize my question is VERY basic, but I am not able to figure it out.
I want to have several Command Buttons on the same worksheet. Each Command Button will need to be "enabled" referencing different cells on a different worksheet.
Ex:
Command Button1 refers to Sheet1.Range ("BC7").
Command Button2 refers to Sheet1.Range ("BC8").
So forth.

I am able to set-up CommandButton1 using Private Sub Worksheet_SelectionChange(ByVal Target As Range). However, when I add CommandButton2, it does not work.

Please Login or Register  to view this content.

Again, I know my question is basic, but I would appreciate any help given!

[Winon]

Moderation removed

[brentjohn]

Winon,
I am sorry for this error. I have followed your instruction (and will do for additional post).

[MarvinP]

Hi Brent,

Code behind worksheets is supposed to be EVENT type code and only work on that individual sheet. If you want code to work across other sheets, you should put it in a Module. (See Insert Module)

Read:

http://www.cpearson.com/excel/Scope.aspx

So the answer is you should have code in a module that is run when you click on those buttons. Each button could run a separate sub. If that doesn't work, then attach the full workbook and explain what you are trying to accomplish.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Roel Jongman]

brentjohn,

you can only have 1 Worksheet_SelectionChange event macro
what you need to do is resolve the activation of your commandbuttons in the same selection event

try the following code to replace yours

Please Login or Register  to view this content.

Cbool translates 0 as false and other values as True

[brentjohn]

Roel,

Thank you much!!! It works perfectly!!!