Home |
Search |
Today's Posts |
#1
|
|||
|
|||
limiting combo box entry
I know there's gotta be a way to limit combo box entry to only listed items
but I can't figure it out. Please let me know what I need to do. As it is right now the user can select any items from the combo box but they can also type directly in the combo box, effectively making the combo box pointless. Thanks! |
#2
|
|||
|
|||
Don't use a combo box, use a listbox, or set the style property to
fmStyleDropDownCombobox -- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... I know there's gotta be a way to limit combo box entry to only listed items but I can't figure it out. Please let me know what I need to do. As it is right now the user can select any items from the combo box but they can also type directly in the combo box, effectively making the combo box pointless. Thanks! |
#3
|
|||
|
|||
List Boxes don't offer the same usability options as combo boxes. So there's
no way to limit combo box entry to selections from the list? Even with VBA or something? If I can get the list box to look and work like a combo box then great but I can't believe there's no way to limit combo box entry. "Bob Phillips" wrote: Don't use a combo box, use a listbox, or set the style property to fmStyleDropDownCombobox -- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... I know there's gotta be a way to limit combo box entry to only listed items but I can't figure it out. Please let me know what I need to do. As it is right now the user can select any items from the combo box but they can also type directly in the combo box, effectively making the combo box pointless. Thanks! |
#4
|
|||
|
|||
What do they not offer other than edit functionality, and first letter
select? -- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... List Boxes don't offer the same usability options as combo boxes. So there's no way to limit combo box entry to selections from the list? Even with VBA or something? If I can get the list box to look and work like a combo box then great but I can't believe there's no way to limit combo box entry. "Bob Phillips" wrote: Don't use a combo box, use a listbox, or set the style property to fmStyleDropDownCombobox -- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... I know there's gotta be a way to limit combo box entry to only listed items but I can't figure it out. Please let me know what I need to do. As it is right now the user can select any items from the combo box but they can also type directly in the combo box, effectively making the combo box pointless. Thanks! |
#5
|
|||
|
|||
Actually, once I selected fmStyleDropDownList instead of fmStyleDropDownCombo
it worked just like I wanted it to. Thanks anyhow! "Bob Phillips" wrote: What do they not offer other than edit functionality, and first letter select? -- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... List Boxes don't offer the same usability options as combo boxes. So there's no way to limit combo box entry to selections from the list? Even with VBA or something? If I can get the list box to look and work like a combo box then great but I can't believe there's no way to limit combo box entry. "Bob Phillips" wrote: Don't use a combo box, use a listbox, or set the style property to fmStyleDropDownCombobox -- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... I know there's gotta be a way to limit combo box entry to only listed items but I can't figure it out. Please let me know what I need to do. As it is right now the user can select any items from the combo box but they can also type directly in the combo box, effectively making the combo box pointless. Thanks! |
#6
|
|||
|
|||
That is what I meant even though I said fmStyleDropDownCombobox
-- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... Actually, once I selected fmStyleDropDownList instead of fmStyleDropDownCombo it worked just like I wanted it to. Thanks anyhow! "Bob Phillips" wrote: What do they not offer other than edit functionality, and first letter select? -- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... List Boxes don't offer the same usability options as combo boxes. So there's no way to limit combo box entry to selections from the list? Even with VBA or something? If I can get the list box to look and work like a combo box then great but I can't believe there's no way to limit combo box entry. "Bob Phillips" wrote: Don't use a combo box, use a listbox, or set the style property to fmStyleDropDownCombobox -- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message ... I know there's gotta be a way to limit combo box entry to only listed items but I can't figure it out. Please let me know what I need to do. As it is right now the user can select any items from the combo box but they can also type directly in the combo box, effectively making the combo box pointless. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic combo boxes | Excel Worksheet Functions | |||
How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
Forcing Combo box entry in VBA | Excel Discussion (Misc queries) | |||
Combo Box Question | Excel Worksheet Functions |