Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering time via combobox | Excel Discussion (Misc queries) | |||
Entering Variable Text in Text Boxes...... | Excel Discussion (Misc queries) | |||
Entering Values into Combobox in Spreadsheet | Excel Discussion (Misc queries) | |||
Need step by step for entering data into combobox | Excel Discussion (Misc queries) | |||
Help!!-combobox with Text | Excel Programming |