sendkeys method - question

[Guest]

hello,
I want to create a simple command button which opens the Find window(CTRL+F) that excel provides by click event. I tried to use the sendkeys method combaind with all the options True \ False, application before, but none of those worked, it doesn't focused on my excel work i guess. help!
shay.

 

[Frank Kabel]

Hi
assign the following code to a shortcut or button

sub show_name()
application.Dialogs(xlDialogFormulaReplace).Show
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

hello,
I want to create a simple command button which opens the Find

window(CTRL+F) that excel provides by click event. I tried to use the
sendkeys method combaind with all the options True \ False, application
before, but none of those worked, it doesn't focused on my excel work i
guess. help!