What is the syntax to check the value of a textbox?

If <textbox name>.Value = "<value textbox should be>" Then
   <code to be run, provided correct textbox value was entered>
End If
'example
If txtName.Value = "" Then
     Msgbox ("No name was entered!")
End If
Advertisements

What is the syntax to populate a combo box?

'method 1
With <combobox name>
     .AddItem “<option 1>     .AddItem “<option 2>      End With

'method 2 - populate from a range
<combobox name>.List = Sheets("<sheet name containing range>").Range("<range index>").Value