Creating a search-field in EXCEL

nifiction

New Member
Joined
Jul 11, 2008
Messages
19
I have created a little custom dictionary with spelling rules for my company (just to define how to spell e.g. "webbased"/ "web-based"/ "web based").

Since I want to users to be able to find the spelling rules quickly in the sheet, I want to integrate a search function into one of the cells. I do not want the standard search function or an VBA, but rather a cell in which you would, in the example, type web*** and then you are taken to the correct entry(ies) in the worksheet.

I am using EXCEL 2003 with OS Windows XP.

Thanks
niLs
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

nifiction

New Member
Joined
Jul 11, 2008
Messages
19
Brian,

Thanks for the hint. Problem is: I have no clue whatsoever as to what to do. Perhaps you have a hint for excel-dummies as well? I assume the code (if that is code anyway) refers to a macro that would create that search function?

Cheers
niLs
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
If you wish to go beyond the normal Excel menu functions then you need to learn more. ;) It takes time and effort. It is a simple choice - either this effort is going to be worthwhile, or it is not.

Start simply by recording a macro of the Find process and adapt the code you get.
 

nifiction

New Member
Joined
Jul 11, 2008
Messages
19
Hey Brian... I guess you are totally right. Well... since my "dictionary" thus far only contains some 200 entries, I guess my employees will have to search alphabetically for the right spelling for now. Thought there might be a simpler way - but I trust your 6k postings that there isn't ;)

Cheers anyway and regards from the Netherlands
niLs
 

hkg003

Active Member
Joined
Apr 6, 2008
Messages
257
nifiction, do you have all of your words in a row of a worksheet? If so, have you tried autofilter? It is a simple but fast search function and it will list anything in that row in alphabetical sequence......

Just my 2 cents ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,095,364
Messages
5,444,027
Members
405,261
Latest member
Khauff

This Week's Hot Topics

Top