close

I am creating a list of part numbers of which some will be similar (different
variants of products) and I want to create a user search function eg a search
box that the users could enter the first few letters followed by a wild card
eg EV* and then the products starting with that prefix would be found.
I know you can use the Find function under Edit, but I was hoping for a more
user friendly tool.
Any ideas.
Regards
Duncan

Data|Filter|Autofilter

And then custom filter: Begins with EV
(or equals EV*)

Maybe...

Duncan, UK wrote:
gt;
gt; I am creating a list of part numbers of which some will be similar (different
gt; variants of products) and I want to create a user search function eg a search
gt; box that the users could enter the first few letters followed by a wild card
gt; eg EV* and then the products starting with that prefix would be found.
gt; I know you can use the Find function under Edit, but I was hoping for a more
gt; user friendly tool.
gt; Any ideas.
gt; Regards
gt; Duncan

--

Dave Peterson

Okay...what Duncan, UK is trying to do is essentially what I am trying to do,
except that I want to make it EVEN EASIER for the user, so that he/she can
enter the text into a Text Box Form and press Enter, and the data will be
AutoFiltered by the text string that they have just entered.

How can I do that?

Thanks!

quot;Dave Petersonquot; wrote:

gt; Data|Filter|Autofilter
gt;
gt; And then custom filter: Begins with EV
gt; (or equals EV*)
gt;
gt; Maybe...
gt;
gt; Duncan, UK wrote:
gt; gt;
gt; gt; I am creating a list of part numbers of which some will be similar (different
gt; gt; variants of products) and I want to create a user search function eg a search
gt; gt; box that the users could enter the first few letters followed by a wild card
gt; gt; eg EV* and then the products starting with that prefix would be found.
gt; gt; I know you can use the Find function under Edit, but I was hoping for a more
gt; gt; user friendly tool.
gt; gt; Any ideas.
gt; gt; Regards
gt; gt; Duncan
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Thanks, that is another way, but I was hoping for a more user friendly way.
eg like a text box on the sheet that performed the same thing. I know how
to find use 'Edit amp; Find' and 'Filters', but the users this is aimed at users
with limited experience and knowledge.

Thanks

quot;Dave Petersonquot; wrote:

gt; Data|Filter|Autofilter
gt;
gt; And then custom filter: Begins with EV
gt; (or equals EV*)
gt;
gt; Maybe...
gt;
gt; Duncan, UK wrote:
gt; gt;
gt; gt; I am creating a list of part numbers of which some will be similar (different
gt; gt; variants of products) and I want to create a user search function eg a search
gt; gt; box that the users could enter the first few letters followed by a wild card
gt; gt; eg EV* and then the products starting with that prefix would be found.
gt; gt; I know you can use the Find function under Edit, but I was hoping for a more
gt; gt; user friendly tool.
gt; gt; Any ideas.
gt; gt; Regards
gt; gt; Duncan
gt;
gt; --
gt;
gt; Dave Peterson
gt;

You can build a textbox (or just a dedicated cell) then show the find dialog.

or maybe...

Even use an addin that's very nice--
Jan Karel Pieterse's FlexFind:
www.oaltd.co.uk/MVP/

But I don't see how anything could be much simpler than Ctrl-f (edit|Find).

Duncan, UK wrote:
gt;
gt; Thanks, that is another way, but I was hoping for a more user friendly way.
gt; eg like a text box on the sheet that performed the same thing. I know how
gt; to find use 'Edit amp; Find' and 'Filters', but the users this is aimed at users
gt; with limited experience and knowledge.
gt;
gt; Thanks
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Data|Filter|Autofilter
gt; gt;
gt; gt; And then custom filter: Begins with EV
gt; gt; (or equals EV*)
gt; gt;
gt; gt; Maybe...
gt; gt;
gt; gt; Duncan, UK wrote:
gt; gt; gt;
gt; gt; gt; I am creating a list of part numbers of which some will be similar (different
gt; gt; gt; variants of products) and I want to create a user search function eg a search
gt; gt; gt; box that the users could enter the first few letters followed by a wild card
gt; gt; gt; eg EV* and then the products starting with that prefix would be found.
gt; gt; gt; I know you can use the Find function under Edit, but I was hoping for a more
gt; gt; gt; user friendly tool.
gt; gt; gt; Any ideas.
gt; gt; gt; Regards
gt; gt; gt; Duncan
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Thanks. I will try that. I know it is easy, but you haven't met the people
that this is intended for....I shouldn't be rude, but honestly they have very
little idea about PCs, let alone Excel.

Cheers

quot;Dave Petersonquot; wrote:

gt; You can build a textbox (or just a dedicated cell) then show the find dialog.
gt;
gt; or maybe...
gt;
gt; Even use an addin that's very nice--
gt; Jan Karel Pieterse's FlexFind:
gt; www.oaltd.co.uk/MVP/
gt;
gt; But I don't see how anything could be much simpler than Ctrl-f (edit|Find).
gt;
gt; Duncan, UK wrote:
gt; gt;
gt; gt; Thanks, that is another way, but I was hoping for a more user friendly way.
gt; gt; eg like a text box on the sheet that performed the same thing. I know how
gt; gt; to find use 'Edit amp; Find' and 'Filters', but the users this is aimed at users
gt; gt; with limited experience and knowledge.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Data|Filter|Autofilter
gt; gt; gt;
gt; gt; gt; And then custom filter: Begins with EV
gt; gt; gt; (or equals EV*)
gt; gt; gt;
gt; gt; gt; Maybe...
gt; gt; gt;
gt; gt; gt; Duncan, UK wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I am creating a list of part numbers of which some will be similar (different
gt; gt; gt; gt; variants of products) and I want to create a user search function eg a search
gt; gt; gt; gt; box that the users could enter the first few letters followed by a wild card
gt; gt; gt; gt; eg EV* and then the products starting with that prefix would be found.
gt; gt; gt; gt; I know you can use the Find function under Edit, but I was hoping for a more
gt; gt; gt; gt; user friendly tool.
gt; gt; gt; gt; Any ideas.
gt; gt; gt; gt; Regards
gt; gt; gt; gt; Duncan
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I've found that if they never get a chance to learn, then they'll never learn.

And by just showing them how to use edit|Find (or ctrl-f), think of all the
other applications that are now a bit easier for them.

Duncan, UK wrote:
gt;
gt; Thanks. I will try that. I know it is easy, but you haven't met the people
gt; that this is intended for....I shouldn't be rude, but honestly they have very
gt; little idea about PCs, let alone Excel.
gt;
gt; Cheers
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; You can build a textbox (or just a dedicated cell) then show the find dialog.
gt; gt;
gt; gt; or maybe...
gt; gt;
gt; gt; Even use an addin that's very nice--
gt; gt; Jan Karel Pieterse's FlexFind:
gt; gt; www.oaltd.co.uk/MVP/
gt; gt;
gt; gt; But I don't see how anything could be much simpler than Ctrl-f (edit|Find).
gt; gt;
gt; gt; Duncan, UK wrote:
gt; gt; gt;
gt; gt; gt; Thanks, that is another way, but I was hoping for a more user friendly way.
gt; gt; gt; eg like a text box on the sheet that performed the same thing. I know how
gt; gt; gt; to find use 'Edit amp; Find' and 'Filters', but the users this is aimed at users
gt; gt; gt; with limited experience and knowledge.
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Data|Filter|Autofilter
gt; gt; gt; gt;
gt; gt; gt; gt; And then custom filter: Begins with EV
gt; gt; gt; gt; (or equals EV*)
gt; gt; gt; gt;
gt; gt; gt; gt; Maybe...
gt; gt; gt; gt;
gt; gt; gt; gt; Duncan, UK wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I am creating a list of part numbers of which some will be similar (different
gt; gt; gt; gt; gt; variants of products) and I want to create a user search function eg a search
gt; gt; gt; gt; gt; box that the users could enter the first few letters followed by a wild card
gt; gt; gt; gt; gt; eg EV* and then the products starting with that prefix would be found.
gt; gt; gt; gt; gt; I know you can use the Find function under Edit, but I was hoping for a more
gt; gt; gt; gt; gt; user friendly tool.
gt; gt; gt; gt; gt; Any ideas.
gt; gt; gt; gt; gt; Regards
gt; gt; gt; gt; gt; Duncan
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()