Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
On click button event
Hi,
Please help me to implement button in an Excel sheet and on click,the button will search for some entered string in a column and calculate the total of each string used in that sheet and according to that a chart will be genareted in another sheet. I am very new in writting Macro,Plz.. help me to do implement this from scratch. Thank you Regards, Niloy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
On click button event
First you go to tools- macro- record new macro. there you enter the name you
want to call the macro, (remember no spaces in the macro name, use "_") you can also enter a shortcut key. Afterward you press enter, and you do manualy what you would want the button to do. then when you finish recording the macro go to tools- macro- press on stop recording. Then go to view- toolbars- forms. press on the button icon, make a box a pop up box will appear you should pick the macro that you recorded, then you press enter. You can use now the button. " wrote: Hi, Please help me to implement button in an Excel sheet and on click,the button will search for some entered string in a column and calculate the total of each string used in that sheet and according to that a chart will be genareted in another sheet. I am very new in writting Macro,Plz.. help me to do implement this from scratch. Thank you Regards, Niloy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A button for Center Across Selection | Excel Discussion (Misc queries) | |||
Click event for checkbox from Forms toolbar | Excel Discussion (Misc queries) | |||
call a function on control click event | Excel Discussion (Misc queries) | |||
Sorting and copying automatically between worksheets | New Users to Excel | |||
When I click buttons I have added the font or button resize, Why? | Excel Discussion (Misc queries) |