Macro to automate 'find' function


Posted by Chris Choulos on August 03, 2001 12:27 PM

I am in need of a macro that will automate the find function. Specifically, I have an excell spreadsheet linked off of a web page that is being used as a searchable database. When the spreadsheet is opened, I would like the 'find' dialog box to come up automatically so that the user can simply enter the text to be located and hit return. Basically, it's automating the manual task of having the user go into the Edit menu and selecting 'find'.

Thanks in advance for any suggestions,

Chris

Posted by Malc on August 03, 2001 12:38 PM

Record a macro doing what you want and see how it works. You might be able to use an input box to fill the find feild.



Posted by Ivan F Moala on August 03, 2001 2:13 PM

Recording a macro will not give you the Find
dialogbox......try this command excel2000

Public Sub sFind()
Application.CommandBars.FindControl(ID:=1849).Execute
End Sub

Ivan