Change color of commandbuttons based in cell values

**mmf** · 08-16-2008, 10:22 PM

Hi
I would like to change the color of a set of commands buttons based in a cell value Fail(red) Pass(green)

I have a main sheet with all the commandbuttos (one for each Item) in the real sheet I have more than 3 items that is the reason I would like to create something like the followint code

then for each Item I have a sheet and in each sheet has a validation cell to choose pass or fail.
But I get an error every time that the main sheet is activate and call the IpdateItemStatus sub
Any help?
Many thanks

Please Login or Register  to view this content.

**Simon Lloyd** · 08-17-2008, 04:42 AM

Your fault is because you haven't qualified the ButtonName because Excel doesn't know which button!

Rather than

Please Login or Register  to view this content.

you should use

Please Login or Register  to view this content.

**Tom Schreiner** · 08-17-2008, 09:39 AM

Hi MMF.

Please provide some more details. Your code contains quite a few errors. Post an example of your file or walk us through by describing which user actions should result in an update of some certain commandbutton's properties. Where are the commandbuttons in relation to the cells containing the conditions? What action results in a condition being changed? Perhaps we could automate this using the worksheet change event...

ItemSheetName does not recieve an assignment.
SheetName is never declared.
Placing option explicit at the top of your modules will require variable declaration.

**mmf** · 08-18-2008, 08:00 AM

Sorry for that, here I am posting the excel sheet with explanation of what I am trying to do.
many thanks and Best Regards

**mmf** · 08-19-2008, 12:22 PM

Hi Simon I was trying this

Please Login or Register  to view this content.

but still not working
I think is because ButtonName is declared as a string, but I do not know how should I declare it in order to be accepted as a command button.

Any further help will be welcomed

Regards
MMf

**Tom Schreiner** · 08-20-2008, 08:50 AM

Sorry for the delay but I have not been able to get to this site. I kept ending up at godaddy.com.

Anyway, replace all of the code in your example with this code located in the workbook class...

Name the PassFail ranges according to the button it relates to. See the attached.

Please Login or Register  to view this content.

Change color of commandbuttons based in cell values

LinkBack

Thread Tools

Rate This Thread

Display

Change color of commandbuttons based in cell values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions