ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   limiting combo box entry (https://www.excelbanter.com/excel-worksheet-functions/10997-limiting-combo-box-entry.html)

tjb

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!

Bob Phillips

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!




tjb

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!





Bob Phillips

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!







tjb

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!







Bob Phillips

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!










All times are GMT +1. The time now is 04:33 PM.

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