MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro help needed!!!!!!!


Posted by Doug Cooper on November 15, 2001 11:38 AM

I have an excel spreadsheet that I want to have 2 buttons on.
1 button to select a table of information & then bring up the form function.
The other button to close the form function & save the data.

Can anyone help????


Posted by Juan Pablo on November 15, 2001 12:04 PM

Have you tried using the macro recorder and then assigning the code to the buttons ? (NT)

Posted by Doug Cooper on November 15, 2001 12:43 PM

Re: Yeap tried that & can't stop the macro...

I have tried recording a macro to do it, but when the form box is up - I can't stop the macro.

Posted by Juan Pablo on November 15, 2001 12:44 PM

Re: Yeap tried that & can't stop the macro...

Stop it later (When you close it) and then go to edit the macro and see what it does, and what needs to be edited.

Juan Pablo

Posted by Juan Pablo on November 15, 2001 12:45 PM

This shouldn't go here... (!?)