List/Combo Box Issues

[SkippyPB]

I have been fooling around with this particular problem for several
weeks now. I've tried everything I found on the Internet but either
I'm not implementing something correctly or I'm just not getting it.

I have Excel 2003 and I'm trying to add data validation, auto complete
and removing a selected entry to cells in my spread sheet.

Here is a sample of my Workbook layout:

Cells C2 and I2 would contain a name selected from a list on another
sheet I call ValidationSheet. Names is a defined range name on the
ValidationSheet (A1:A705).

Cells D2 and J2 contain a position. Positions is also defined as a
range name on the ValidationSheet (B1:B10);

Cells E2 and K2 contain a location. Location is also defined as a
range name on the ValidationSheet(C1:C100).

And as a matter of full disclouser, this pattern is repeated in 9 more
rows, i.e., C3 and I3 are a name; D3 and J3 are a position, etc.

I've been able to set up data validation with no problem, but you
don't get auto completion with it and scroling through over 700
entries is no fun. I've tried using combo boxes becuase it does have
auto completion but it is not working to my satisfaction and it
doesn't remove or blank out an item once it has been selected. This
option would only be for names.

Any examples I can use to accomplish this would be very appreciated.

Thanks.
(o o)
-oOO--(_)--OOo-
Two boll weevils grew up in South Carolina.
One went to Hollywood and became a famous actor.
The other stayed behind in the cotton fields and
never amounted to much.
The second one, naturally, became known as the
lesser of two weevils.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Remove nospam to email me.

Steve

 

[Don Guillett]

I have been fooling around with this particular problem for several
weeks now.  I've tried everything I found on the Internet but either
I'm not implementing something correctly or I'm just not getting it.

I have Excel 2003 and I'm trying to add data validation, auto complete
and removing a selected entry to cells in my spread sheet.

Here is a sample of my Workbook layout:

Cells C2 and I2 would contain a name selected from a list on another
sheet I call ValidationSheet.  Names is a defined range name on the
ValidationSheet (A1:A705).

Cells D2 and J2 contain a position.  Positions is also defined as a
range name on the ValidationSheet (B1:B10);

Cells E2 and K2 contain a location.  Location is also defined as a
range name on the ValidationSheet(C1:C100).

And as a matter of full disclouser, this pattern is repeated in 9 more
rows, i.e., C3 and I3 are a name; D3 and J3 are a position, etc.

I've been able to set up data validation with no problem, but you
don't get auto completion with it and scroling through over 700
entries is no fun.  I've tried using combo boxes becuase it does have
auto completion but it is not working to my satisfaction and it
doesn't remove or blank out an item once it has been selected.  This
option would only be for names.

Any examples I can use to accomplish this would be very appreciated.

Thanks.
            (o o)
       -oOO--(_)--OOo-
Two boll weevils grew up in South Carolina.
One went to Hollywood and became a famous actor.
The other stayed behind in the cotton fields and
never amounted to much.
The second one, naturally, became known as the
lesser of two weevils.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Remove nospam to email me.

Steve

"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[SkippyPB]

"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

Done.

Thanks.
(o o)
-oOO--(_)--OOo-
Two boll weevils grew up in South Carolina.
One went to Hollywood and became a famous actor.
The other stayed behind in the cotton fields and
never amounted to much.
The second one, naturally, became known as the
lesser of two weevils.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Remove nospam to email me.

Steve