Thread: If statement for a combo box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
  
Posts: 486
Default If statement for a combo box
This check the length of the text in the combobox...

If CBool(Len(ComboBox1.Text)) Then
MsgBox "Something"
Else
MsgBox "Nothing"
End If

Just change ComboBox1 to the name of your combobox...
--
HTH...

Jim Thomlinson


"Amber_D_Laws" wrote:


In one of my subroutines I want to test for an option in a certian
combobox. It doesn't matter which option the user has choosen, just
that they have chosen one at all.

How do I word the If statement to test for this.

Thanks in advance for any help!
Amber


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=509553


Reply With QuoteReply With Quote