Excel Combo Box - Overriding Values

[vickycmha]

I have created a combo box in an Excel spreadsheet and assigned a range of values to populate it. I would like the user to have the ability to override the value options if necessary to type in an alternate value. Is this possible? If so, how is it done?

 

[SkipVought]

Hi,

Not without code. Please repost in VBA Visual Basic for Applications (Microsoft) Forum707.

Include what type of control you are using.

Skip,

_[red][/red]

 

[Rofeu]

Hi,

if you're using an oleobject, then you require code to do this and you should post in the forum Skip mentions.

However, if you're using an ActiveX object, you can set the property MatchRequired. Default is FALSE. This allows users to enter values other then the ones in the list provided.

Cheers,

Roel

 

[SkipVought]

...however, it does not ADD to the existing list.

Skip,

_[red][/red]

 

[vickycmha]

Thank you. Unfortunately, I have no experience in Visual Basics or ActiveX. I added the combo box through the Control Toolbox in Excel, selected and named the value range. I have tried changing the MatchRequired property to False, but it still won't allow the override.

Vicky

 

[GlennUK]

Vicky, what exactly is happening when you say "it won't allow the override"? I have no problem with this ( Excel 97 ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

Check the MatchEntry property - should be NONE.

Skip,

_[red][/red]

 

[vickycmha]

I have set up my list of values with the most frequently used values. However, there can be one time entries necessary which can't be anticipated. I would like users to have the ability to type in a value other than the choices on the list.

 

[vickycmha]

I have selected "2 - fmMatchEntryNone" for MatchEntry, but it had no affect.

 

[SkipVought]

MatchRequired = FALSE

You must check each Property to see if that setting will work with what you want. It is detailed and time consuming, but this is what programmers have to do.

Skip,

_[red][/red]

 

[vickycmha]

MatchRequired is set at False
MatchEntry is set at 2 - MatchEntryNone

I have gone through each detail of the properties, but can't get it to work the way I'd like. I am working in Excel 2000 if that makes a difference.

I certainly don't have the skillset of a programmer, so it appears I'll have to forego the ability to select from a list.

Thank you for your time.
Vicky

 

[SkipVought]

Work at it because it will work. It worked for Glenn in 97 and me in 2003.

Skip,

_[red][/red]