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