sendkeys method - question

T

TnT

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.
 
F

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

TnT said:
hello,
I want to create a simple command button which opens the Find
Click to expand...
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!
 
Top