Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a command button in excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using a command button in excel
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 ToolsMacroRecord 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 wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print command from command button in userform causes double chart | Excel Programming | |||
Deselect Command Button by Selecting another Command Button | Excel Programming | |||
VB's Command Button vs Form's Command Button | Excel Programming | |||
Command Button in Excel | Excel Programming | |||
excel, vba, command button | Excel Programming |