Dynamic Row Color Change w/ checkbox

**BlueAcrux** · 12-23-2008, 09:27 AM

I havent done any VBA stuff since 99, so amazing to what one can forget.

Im looking to have checkboxes on say rows 1-50 and if that check box is check, the entire row through a range of say A1:J1 turns to green.

Any help with this would be great not even sure if I have a good starting point working, i keep getting a debug on If checkbox1.value = True Then. Thought this was a simple line, but its fighting me.

Working in 07.

Thanks!
enjoy the holidays!

**VBA Noob** · 12-23-2008, 09:35 AM

This old thread may help

http://www.excelforum.com/excel-prog...nge-macro.html

VBA Noob

**royUK** · 12-23-2008, 09:39 AM

I wouldn't use checkboxes. Use the double click event and this code

Please Login or Register  to view this content.

To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you want bthe code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

Dynamic Row Color Change w/ checkbox

LinkBack

Thread Tools

Rate This Thread

Display

Dynamic Row Color Change w/ checkbox

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions