Using a Command Button to colour cells

[Wibs]

Hi,

I have a huge family tree in Excel, and what I would like to do is to put a Command Button on the worksheet, labelled 'John Blanshard's Will' (I can do that bit!), and when it is clicked all the legatees in his will light up, in light orange, for example.

So how do I make the Command Button, when clicked, change the colour of, A2:B3 and E2:F4, to Yellow, for example?

Many thanks

Wibs

[Wibs]

Hi,

I have a huge family tree in Excel, and what I would like to do is to put a Command Button on the worksheet, labelled 'John Blanshard's Will' (I can do that bit!), and when it is clicked all the legatees in his will light up, in light orange, for example.

So how do I make the Command Button, when clicked, change the colour of, A2:B3 and E2:F4, to Yellow, for example?

Many thanks

Wibs

Easy peasy.

Use this code for the Command Button's Click Event:

Range("A2:B3,E2:F4").Select
With Selection.Interior
.ColorIndex = 40
.Pattern = xlSolid
End With

Found it myself folks, I just started the Record Macro, selected and coloured the cells I wanted, stopped the Recorder, then examined the Macro.

So sweeter when you find it yourself.

Regards to all,

Wibs