Combox Help!

's Computer Specifications

Hi,

Using MS Excel 2003 - VBA.

I have a combox with a list of states. How can I prevent the user from
entering a manual item into that list? I only want them to select the states
I have populated into the list. I couldn't find a "Limit to List" property.
:-(

's Computer Specifications

Hi,

In design mode right click it and 'Properties' and change the style property
to

frmStyleDropDownList

Mike

"PumaMan" wrote:

> Hi,
>
> Using MS Excel 2003 - VBA.
>
> I have a combox with a list of states. How can I prevent the user from
> entering a manual item into that list? I only want them to select the states
> I have populated into the list. I couldn't find a "Limit to List" property.
> :-(

's Computer Specifications

May God bless you and your family for 5 generations!!!!!!!!!!!!!!!!!!!!!

Thanks! :-)

"Mike H" wrote:

> Hi,
>
> In design mode right click it and 'Properties' and change the style property
> to
>
> frmStyleDropDownList
>
> Mike
>
> "PumaMan" wrote:
>
> > Hi,
> >
> > Using MS Excel 2003 - VBA.
> >
> > I have a combox with a list of states. How can I prevent the user from
> > entering a manual item into that list? I only want them to select the states
> > I have populated into the list. I couldn't find a "Limit to List" property.
> > :-(

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filter a combox based on selection from another combox	David	Microsoft Access Form Coding	2	22nd Jan 2010 12:05 AM
combox box	Steve	Microsoft Excel Programming	2	4th Jun 2009 06:47 PM
Combox	Ranjit kurian	Microsoft Access Forms	1	27th Sep 2008 05:03 AM
combox	=?Utf-8?B?U291cmlz?=	Microsoft Access Forms	7	12th Jul 2005 04:58 PM
<ALL> in Combox Box?	=?Utf-8?B?Sm9l?=	Microsoft Access	4	27th May 2004 03:50 PM