macro to find cell

jameschez15 · Mar 8th, 2002, 02:59 AM

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 · Mar 8th, 2002, 04:05 AM

Hi

How about

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

jameschez15 · Mar 8th, 2002, 05:18 AM

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 · Mar 8th, 2002, 05:20 AM

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

Audiojoe · Mar 8th, 2002, 05:22 AM

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 · Mar 8th, 2002, 07:14 AM

jameschez15 · Mar 8th, 2002, 07:14 AM

thankyou so much

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 02:59 AM	#1
jameschez15 New Member Join Date: Mar 2002 Location: hull Posts: 4	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

Mar 8th, 2002, 04:05 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi How about Sub MyFind() Application.Dialogs(xlDialogFormulaFind).Show End Sub

Mar 8th, 2002, 05:18 AM	#3
jameschez15 New Member Join Date: Mar 2002 Location: hull Posts: 4	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

Mar 8th, 2002, 05:20 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Is the button doing anything else apart from the Find function?

Mar 8th, 2002, 05:22 AM	#5
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	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 ]

Mar 8th, 2002, 07:14 AM	#6
jameschez15 New Member Join Date: Mar 2002 Location: hull Posts: 4