coding

[samantha]

I am trying to write a piece of code which takes into account multiple controls and is as such :-


Sub calculate
If combobox1 and combobox2 = "Section" and combobox3 and combobox4 = "Branch" then.........

How do i write the above so that vba will accept it.

Thanks,

Samantha

 

[TommyGun]

If ((ComboBox1 = "Section") And (ComboBox2 = "Section")) And ((ComboxBox3 = "Branch") And (ComboBox4 = "Branch")) Then