Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Art is offline
external usenet poster
 
Posts: 587
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A button for Center Across Selection Jaleel Excel Discussion (Misc queries) 4 October 3rd 06 06:06 AM
Click event for checkbox from Forms toolbar Carolyn Excel Discussion (Misc queries) 6 September 11th 06 08:16 PM
call a function on control click event tkraju via OfficeKB.com Excel Discussion (Misc queries) 7 August 25th 06 07:22 AM
Sorting and copying automatically between worksheets nadia New Users to Excel 2 February 12th 06 11:18 PM
When I click buttons I have added the font or button resize, Why? Chris Excel Discussion (Misc queries) 2 October 26th 05 10:31 PM


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"