ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ComboBox - Entering Text (https://www.excelbanter.com/excel-programming/308068-combobox-entering-text.html)

Richard Buttrey[_5_]

ComboBox - Entering Text
 
Hi,

I've got a ComboBox which correctly contains data specified in the
..RowSource property. However I can't get it to accept text, which the
user may wish to enter instead of choosing one of the values presented
in the drop down list.

I've set the Style property to 0 (fmStyleDropDownCombo) as the Help
screen suggests, but it still won't accept a user input.

Any ideas anyone?

TIA

Richard Buttrey

JulieD

ComboBox - Entering Text
 
Hi Richard

ensure "Match required" is set to false

hope this helps
Cheers
JulieD

"Richard Buttrey" wrote in message
om...
Hi,

I've got a ComboBox which correctly contains data specified in the
.RowSource property. However I can't get it to accept text, which the
user may wish to enter instead of choosing one of the values presented
in the drop down list.

I've set the Style property to 0 (fmStyleDropDownCombo) as the Help
screen suggests, but it still won't accept a user input.

Any ideas anyone?

TIA

Richard Buttrey




Tom Ogilvy

ComboBox - Entering Text
 
is the property MatchRequired set to false?

--
Regards,
Tom Ogilvy

"Richard Buttrey" wrote in message
om...
Hi,

I've got a ComboBox which correctly contains data specified in the
.RowSource property. However I can't get it to accept text, which the
user may wish to enter instead of choosing one of the values presented
in the drop down list.

I've set the Style property to 0 (fmStyleDropDownCombo) as the Help
screen suggests, but it still won't accept a user input.

Any ideas anyone?

TIA

Richard Buttrey




Richard Buttrey

ComboBox - Entering Text
 
Thanks Julie & Tom

I hadn't spotted that one.

The help screen wasn't particularly helpful, and didn't mention this
Match property in the first combobox help screen.

Anyway, all is now well.

Kind regards,

Richard


On Thu, 26 Aug 2004 08:27:06 -0400, "Tom Ogilvy"
wrote:

is the property MatchRequired set to false?


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com