Combo Box in VB Forms help

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Combo Box in VB Forms help

FAQ

Thread Tools

Display Modes

05-12-2011, 12:56 PM

Cbrehm

Windows 7 64bit Combo Box in VB Forms help

Office 2003

Novice

Join Date: May 2011

Posts: 8

Combo Box in VB Forms help

Code:

If addtacourt.Value Is Empty Then  'combobox
    MsgBox ("You must choose a court of Jurisdition")
    addtacourt.SetFocus
    Exit Sub
 Else
 End If

Returns an error
I have tried . text and =""'

With the Sample attached run ADDTA form in vb

Use zip 71295 in zip code as I know it is in there (only LA<AR<MS states are in the zipcode range)
Why does this work with textbox but not with combobox?

Attached Files

Tax sale program.xls (274.5 KB, 16 views)

Last edited by Cbrehm; 05-12-2011 at 03:36 PM.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combo Box populate from range	ioustinos	Excel	1	09-01-2010 09:18 AM
Combo Box in whole column	ioustinos	Excel	1	09-01-2010 01:24 AM
Forms - Combo Box Linking data	tomkat	Word	1	04-23-2010 06:28 AM
VB Code.. COmbo boxes	DrewB	Word VBA	4	06-10-2009 05:31 AM
Hide a combo box	DrewB	Word	3	06-08-2009 11:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 AM.