using a command button in excel

[Comand Button n Excel-Plzz help]

Hi..

I am making a product price calculation sheet for my company & want to know
how i can use a command button.

with a command button can be name as ADD & once clicked should save all the
details in the current sheet to a cumulative excel sheet.

With this i can create a cumulative sheet where i can see all the data i
have seleted.

Please HELP...

Thanks & regards

 

[JLGWhiz]

The command button is a tool that creates an event which triggers an action
That action is determined by a procedure (macro) which is either attached
(button from Forms Toolbar) to the button, or part of the event (button from
Control Toolbar). In either case, it is the procedure that does the work
and determines what actions occur. So for the button to do what you want,
you would need to write a code procedure that does the steps. You can
record the macro for most of the steps that you can perform manually. Click
Tools>Macro>Record New Macro. When the toolbar with the Stop Recording
button appears you can start performing the manual steps for what you want
to do. When you have completed those steps, click the stop recording button
and view the results by pressing Alt+F11.




"Comand Button n Excel-Plzz help" <Comand Button n Excel-Plzz
(e-mail address removed)> wrote in message
news:[email protected]...