Change Command Button Colour Based on Cell

[adam.hewitt5]

Hi All,

i would like to change the colour of a command butoon based on whether or not a cell has content in it. The code i have so far is:

 

  If Sheets("work").Range("m8") = "" Then
  Exit Sub
  
  Else
    
  Me.CommandButton3.BackColor = &HFF66FF
  
  
  End If

Also when trying to change the colour of the button manually without any coding, it does not change, it just stays the normal grey colour.

Thanks in advance.

Adam[COLOR="Silver"]

[Mordred]

I didn't have any issues with your code while it is in a userform. Is that where your code is?

[HSV]

Try this:

Me.CommandButton3.BackColor = IIf(Sheets("work").Range("m8") > 0, &HFF66FF, &H8000000F)

[adam.hewitt5]

yes my code is in a userform. It will allow me to change the forecolor but not the back colour

[adam.hewitt5]

HSV that isnt working either

[jolivanes]

See if you can gleam anything from attached.
It works on MS computer.

[HSV]

HSV that isnt working either

Then upload your file.

[adam.hewitt5]

i have decided to just either change the font colour or change the text on the button.

Thanks anyway

Adam