Assigning Macros to Buttons
 

I have created an Excel spreadsheet that contains a list that is similar to a
library index... title of document, author, date etc.

For those users who are unfamiliar with Excel I want to create a button that
when you click on it the Find dialogue box comes up automatically.

Excel has already automatically assigned the shortcut Crtl F to bring up
this dialogue- how do I link this to a box??? When I attempt to create a
Macro that brings up this box I can't - I can record a macro that will add
two plus two and do all kinds of great calculations but all I want to do is
bring up the Find dialogue.

I also want to do the same thing on another button that will select the
entire list and bring up the SORT dialogue box - however when you bring up
this dialogue you can't click out of it so i can't stop recording the macro.

Thank you sooo much for your help!

Assigning Macros to Buttons
 

Put this line in your macro

Application.Dialogs(xlDialogFormulaFind).Show


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Christine" wrote in message
...
I have created an Excel spreadsheet that contains a list that is similar to
a
library index... title of document, author, date etc.

For those users who are unfamiliar with Excel I want to create a button
that
when you click on it the Find dialogue box comes up automatically.

Excel has already automatically assigned the shortcut Crtl F to bring up
this dialogue- how do I link this to a box??? When I attempt to create a
Macro that brings up this box I can't - I can record a macro that will add
two plus two and do all kinds of great calculations but all I want to do
is
bring up the Find dialogue.

I also want to do the same thing on another button that will select the
entire list and bring up the SORT dialogue box - however when you bring up
this dialogue you can't click out of it so i can't stop recording the
macro.

Thank you sooo much for your help!