Combobox - MatchRequired does not work?

[Wim SKW]

Hi,

I'm using Excel 2002 SP3 and I have a control toolbox ComboBox on a sheet.
The properties are:
LinkedCell: B4 (range on the same worksheet)
ListFillrange: H2:H5 (H2=London, H3=Luxemburg, H4=Berlin, H5=Brussels)
MatchEntry: 1 - fmMatchEntryComplete
MatchRequired: True
Style: 2 - fmStyleDropDownCombo

The help file says about MathRequired:
Specifies whether a value entered in the text portion of a ComboBox must
match an entry in the existing list portion of the control. The user can
enter non-matching values, but may not leave the control until a matching
value is entered.

The odd thing is that I can type anything I want, the LinkedCell gets
updated with each keystroke and I can leave the combobox - even if the value
does not match an entry in the list!

Am I missing something here?
Any help appreciated.
-=Wim=-

 

[witek]

Hi,

I'm using Excel 2002 SP3 and I have a control toolbox ComboBox on a sheet.
The properties are:
LinkedCell: B4 (range on the same worksheet)
ListFillrange: H2:H5 (H2=London, H3=Luxemburg, H4=Berlin, H5=Brussels)
MatchEntry: 1 - fmMatchEntryComplete
MatchRequired: True
Style: 2 - fmStyleDropDownCombo

The help file says about MathRequired:
Specifies whether a value entered in the text portion of a ComboBox must
match an entry in the existing list portion of the control. The user can
enter non-matching values, but may not leave the control until a matching
value is entered.

The odd thing is that I can type anything I want, the LinkedCell gets
updated with each keystroke and I can leave the combobox - even if the value
does not match an entry in the list!

change style to dropdownlist

 

[Phil Moisey]

For matchentry=true property of the combobox to work on the the excel worksheet it seems that you need to set the "style" property to 2. It certainly isnt obvious or intuitive.




WimSK wrote:

Combobox - MatchRequired does not work?
25-Jul-07

Hi

I'm using Excel 2002 SP3 and I have a control toolbox ComboBox on a sheet
The properties are
LinkedCell: B4 (range on the same worksheet
ListFillrange: H2:H5 (H2=London, H3=Luxemburg, H4=Berlin, H5=Brussels
MatchEntry: 1 - fmMatchEntryComplet
MatchRequired: Tru
Style: 2 - fmStyleDropDownComb

The help file says about MathRequired
Specifies whether a value entered in the text portion of a ComboBox must
match an entry in the existing list portion of the control. The user can
enter non-matching values, but may not leave the control until a matching
value is entered

The odd thing is that I can type anything I want, the LinkedCell gets
updated with each keystroke and I can leave the combobox - even if the value
does not match an entry in the list

Am I missing something here
Any help appreciated
-=Wim=-

Previous Posts In This Thread:

Combobox - MatchRequired does not work?
Hi

I'm using Excel 2002 SP3 and I have a control toolbox ComboBox on a sheet
The properties are
LinkedCell: B4 (range on the same worksheet
ListFillrange: H2:H5 (H2=London, H3=Luxemburg, H4=Berlin, H5=Brussels
MatchEntry: 1 - fmMatchEntryComplet
MatchRequired: Tru
Style: 2 - fmStyleDropDownComb

The help file says about MathRequired
Specifies whether a value entered in the text portion of a ComboBox must
match an entry in the existing list portion of the control. The user can
enter non-matching values, but may not leave the control until a matching
value is entered

The odd thing is that I can type anything I want, the LinkedCell gets
updated with each keystroke and I can leave the combobox - even if the value
does not match an entry in the list

Am I missing something here
Any help appreciated
-=Wim=-

Re: Combobox - MatchRequired does not work?
Wim SKW wrote

change style to dropdownlist


Submitted via EggHeadCafe - Software Developer Portal of Choice
Code Recommendations For COM+ VB Developers
http://www.eggheadcafe.com/tutorial...69-b803b114a18d/code-recommendations-for.aspx