Cell color changing

[jjohnson3333]

Hey all,

I'm not the most experienced at programming beyond the basics. How would I code, using a command button, changing the color of cells. I've gotten it to work in macro form but it seems to crash writing it into a command button statement. Thanks.

[MDubbelboer]

maybe post the code you have working with the macro and explain what exactly you'd like done when the command button is pressed

i.e. change cell d7 to green if c3=true

[nomadscot]

Hi Mark,

I'm trying to learn about Events macros so that I can use one in a spreadsheet I'm building, but the problem is more fundamental than actually trying to achieve a specific event. I copied and pasted this macro from a web site:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "You just changed " & Target.Address
End Sub

but I cannot get it run. I've tried others, and they work a few times and then pack up.

Now you cannot get more basic than that little bit of code, can you? So as I say, they problem is not in the code itself.

Why should they run a few times, and then stop?

[nomadscot]

...and I've just realised what I've done! Sorry!

The wife came in and distracted me. That's my excuse.

Don't y'all go off thinking " Well if he can't even read a forum correctly, how does he expecvt to run a macro?"

(Although I'd understand it if you did)



And sorry for disturbing your thread jjjjj)