Assigning Macros to Buttons

[Christine]

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!

[Peo Sjoblom]

Put this line in your macro

Application.Dialogs(xlDialogFormulaFind).Show


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Christine" <[email protected]> wrote in message
news:[email protected]...
>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!