Thread: Combox Help!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Combox Help!

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.
:-(