Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel button to change cell colour

Comment:

Hi, I want to change cell A2 colour to equal cell A1 colour when I click a button. I have a button and need the code please! What I have already to change the value is: range("a2").value = range("a1").value This changes the value in the cell. (I just need the colour to change as well. Thank you. Lee

Name: DerbyDad03
Date: August 4, 2009 at 06:15:09 Pacific

Reply:

To answer your specific question, the code to make the fill colors the same is: Range("A2").Interior.ColorIndex = Range("A1").Interior.ColorIndex Another option is to simply copy/paste the cell which will copy the value and all formating in one line: Range("A1").Copy Destination:=Range("A2")

0

Reply:

Thank you DerbyDad03 That is exactly what I needed. Cheers

0

Word orrupted

Looking for recovery disk...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I need to prepare a weekly progress chart of a construction project. For this purpose I maintain a sheet wherein I put the progrees of work after the end of each week. In this sheet progress of work f...

Summary: Hi, I want to change the colour of the cell when some value is entered in the cell and i want to configure this for the whole work sheet...... Can anyone help me on this, i know its a primitive questi...

Summary: Yes it can, you create it like a formula using IF THEN ELSE statements, checking for the current MONTH, not the day. Read up your Excel Help documentation on this, the usage is there along with an exa...