How do I embed FIND function in a cell

F

fhires

I am creating a large excel file that has lots of info that several people
will need to search through that have limited computer knowledge. To make it
easier on them is there a way to embed the FIND function into a cell that is
easy for them to find and use. They can't seem to remember that Ctrl+F gets
them what they need and they seem to lose the icon from their tool bars every
time I place it there.
 
P

Pringles.

well you could always just make a BRIGHT RED cell that tells them how to find
it.
 
P

Pringles.

but if you enter an interacive text box somewhere i'm sure there's a way to
get it to seach for text within the sheet.
 
F

fhires

Like I inferred...I'm trying to make it idiot proof and i've tried all of
that type of stuff.
 
G

Gord Dibben

Just about the time you think you have it "idiot-proof" a newly-mutated strain
of idiots will arrive on the scene.

Enable the Forms Toolbar. Click on the Button Icon.

Draw a large button on the worksheet.

Right-click on Button and "Edit Text". Type in an appropriate message.

Right-click again.

Assign this macro which you have copied and pasted into a general module in
the workbook.

Sub findit()
Application.SendKeys ("^f")
End Sub

Warning: one of the idiots will find a way to clear the button from the
sheet<g>

Although you could Protect the Worksheet and not allow Objects to be
edited/deleted.

Password the protection.

Whoops! Someone could crack the Password<g>

Gord Dibben Excel MVP
 
D

Dave Peterson

Just my opinion...

You can treat the users like dopes and they'll continue to be dopes.

If you encourage them to learn ctrl-f (edit|find), they might find that it's
useful in almost all windows programs.

Give a man a fish and he'll eat for a day. Teach a man to fish and he'll never
go hungry.

(or teach a man to fish and you'll never see him on a Sunday morning???)
 
Top