Command color change upon a click

Here is an example of how command button color
properties can be changed in the button's click event.

Please Login or Register  to view this content.

hi there i have tried xLJer's code in a workbook of mine with acommand button and it seems to work fine.

on the module do you have this present

Please Login or Register  to view this content.

Also check that the Button you want to change colour is called CommandButton1. To do this on the form click the button and check it's properties.

If it is called something different then change the replace all the "CommandButton1"'s in the code to whatver you have called the command button. or just change the name of the command button to Command Button 1

Hope this helps.

Hi Jayruss

Thanks for the reply.

I have attached an excel with what I am doing.

Sheet1, I have inserted the command button from control toolbox toolbar. I am using the code same as xLJer has given. It does not do anything when I double click the commandbutton it just opens the code.

Sheet2, I have added the Button from Forms Toolbar. I have edited the code to match the label name and macro name and assigned the Test_Color_Change macro to the code. It gives me 'Expected Function or Variable' error.

I appreciate your time and patience...:-)

Thanks,
Su.

Should work Now, i used an Activex button instead of and actual form button and now all works. just to let you know i am new to VBA aswell therefore my workaround may not be the most elegant. however it does work attacthed is the updated worksheet.

@ macrofan2012

Welcome to the forum.

Please notice that [CODE] tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

That works but I can't really use it for my purpose unless I know how does the code works for a form toolbar command box as I am using excel 2003. Sorry.

I have a long code for other formulas etc, everything works perect. All I need is to incorporate the color change code in the same macro and I am all done.

Anyone can help me on this please. Would be great if someone can explain how doe this work for forms toolbar.

Thanks for having a look anyways..:-)
Su.

Unfortunatley you cannot change the colour of a standard form button.

One workaround would be to insert a line of code into your existing code that changes the colour of a cell next to the button to determine wether the code has been run or not ?

Furthermore i ran a compatibility check on the Workbook i gave you and no compatabililty issues came about, so you should be able to use the code that i gave to you and within that same module of "CommandButton1_(Click)" just copy the rest of the code you have already written into said module and all should run fine (fingers crossed)

I do not know how to assign this code to a commandbutton.

I was just googling this and nothing helps me out.

I right clicked the command button and selected view code where I had pasted this code. To assign the code I right clicked again and selected property and then closed the code and property. But after that when I click command button it only opens the code and nothing happens unfortunately.

This is really annoying. Why excel can't be simple and easy. I like using forms button it atleast says to assign macros. Excel has some features with some not others. Everytime you struggle for silly things.

Anyone can help resolving this issue please.

Thank you very much xLJer for the explanation. it solved my problem....hurrrah.

I really appreciate....muah..:-)

Thanks,
Su.