software

How can I limit the people using my spreadsheet to the list of client
names listed? My list works great, but instead of selecting Gino's from
the drop down list, they type in quot;Ginos.quot; I've search Data Validation
and see the Warning message options, but not a limit to list option.

Also, I know if I have quot;Gino'squot; in the column cell once, then the next
time someone types quot;Gquot; in a cell that quot;Gino'squot; will pop up. Is there a
way to have this happen the first time some types a quot;G?quot;

-Chuck---
Dropdown3
------------------------------------------------------------------------
Dropdown3's Profile: www.excelforum.com/member.php...oamp;userid=30321
View this thread: www.excelforum.com/showthread...hreadid=518753I don't think that there's a good way to limit the use of your workbook--except
not give it out to people who shouldn't use it--and only give it to trustworthy
users. (Sorry.)

And this autocomplete is actually a user setting.
Tools|Options|edit tab|enable autocomplete for cell values.
It uses the cells above and below to help guess what you want.

Data|validation doesn't provide this ability for matching entries. But a
combobox from the control toolbox toolbar does have this ability.

Dropdown3 wrote:
gt;
gt; How can I limit the people using my spreadsheet to the list of client
gt; names listed? My list works great, but instead of selecting Gino's from
gt; the drop down list, they type in quot;Ginos.quot; I've search Data Validation
gt; and see the Warning message options, but not a limit to list option.
gt;
gt; Also, I know if I have quot;Gino'squot; in the column cell once, then the next
gt; time someone types quot;Gquot; in a cell that quot;Gino'squot; will pop up. Is there a
gt; way to have this happen the first time some types a quot;G?quot;
gt;
gt; -Chuck-
gt;
gt; --
gt; Dropdown3
gt; ------------------------------------------------------------------------
gt; Dropdown3's Profile: www.excelforum.com/member.php...oamp;userid=30321
gt; View this thread: www.excelforum.com/showthread...hreadid=518753

--

Dave Peterson


I have distributed the worksheet the appropriate persons, that's not the
issue. The problem I'm having is limiting their options to only the
clients listed in the list box.

-Chuck---
Dropdown3
------------------------------------------------------------------------
Dropdown3's Profile: www.excelforum.com/member.php...oamp;userid=30321
View this thread: www.excelforum.com/showthread...hreadid=518753How did you create the dropdown?

If you used a combobox from the control toolbox toolbar, then change the .style
to fmStyledropdownlist.

If you use data|validation, make sure that you stop any invalid entry.

If you used something else, then you'll have to share that.

Dropdown3 wrote:
gt;
gt; I have distributed the worksheet the appropriate persons, that's not the
gt; issue. The problem I'm having is limiting their options to only the
gt; clients listed in the list box.
gt;
gt; -Chuck-
gt;
gt; --
gt; Dropdown3
gt; ------------------------------------------------------------------------
gt; Dropdown3's Profile: www.excelforum.com/member.php...oamp;userid=30321
gt; View this thread: www.excelforum.com/showthread...hreadid=518753

--

Dave Peterson

And make sure there aren't any blank cells in the source list, or people
will be able to type any entry in the cell with data validation.

Dave Peterson wrote:
gt; How did you create the dropdown?
gt;
gt; If you used a combobox from the control toolbox toolbar, then change the .style
gt; to fmStyledropdownlist.
gt;
gt; If you use data|validation, make sure that you stop any invalid entry.
gt;
gt; If you used something else, then you'll have to share that.
gt;
gt; Dropdown3 wrote:
gt;
gt;gt;I have distributed the worksheet the appropriate persons, that's not the
gt;gt;issue. The problem I'm having is limiting their options to only the
gt;gt;clients listed in the list box.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html