Solved Vba backcolor

[skdn71]

Hello,

Could you please help with VBA

If value on Text box, the Box1 backcolor must be Red ( see picture)
If value on combobox the Box2 backcolor must be Red ( see picture)

Thank you

 

[Gasman]

No VBA needed, use Conditional formatting.

 

[skdn71]

I try with conditional formating but not working, I get color on Textbox instead of Box1

Please help

 

[Gasman]

You are using the wrong button.
Use the one next to the Undeline button.

 

[skdn71]

I get the same result

 

[Gasman]

The CF has to be in the control you are trying to use it on?

You are using it on the field you are testing? However are you testing for anything? You need to test if the large controls are empty or not.

Anyway it show it is working, just on the wrong control.

 

[skdn71]

I Can't use conditional formating on Box1 please check the attachement i can do only on Textbox

 

[Gasman]

Sorry, I did not realise you actuall had a box, I thought that was just your techincal name for the control.
As you mention, they do not have a CF option.

So code as you requested.

Private Sub Naam_AfterUpdate()
If Not Me.Naam & "" = "" Then
    Me.Box1.BackColor = vbRed
End If
End Sub

However you have the backstyle as Transparent, so will never see the colour until you change that.

 

[skdn71]

Dear Gasman,

Is working Thank you so much