macro to find cell

[jameschez15]

All i want to do is create a button that performs the alt+F function to find a cell. i have a list of names and i want a button at the top of the page to press alt+F. or something similar. when I try to record it to do this the find function is in grey text meaning i cant select it. plz help
james

 

[Dave Hawley]

Hi

How about

Sub MyFind()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

 

[jameschez15]

i cannot get this to work still when i edit the macro do i delete what is already in it, allt he sub bit and stuff? i dont know how to write all the code. ive tried a few variations and still cannot get it to work, help appreciated though. argh coursework due in in a couple of hours. plz help thanx

 

[Audiojoe]

Is the button doing anything else apart from the Find function?

 

[Audiojoe]

The best thing to do is go into VBA, insert a module, then copy and paste Dave's code into it, cos it works great. Then just go back into Excel, and assign the MyFind macro to your button by right clicking it
This message was edited by audiojoe on 2002-03-08 04:32

 

[jameschez15]

[No message]

 

[jameschez15]

thankyou so much