Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Check Box and Button Macros


I have a quick question that I haven’t seen answered here before
(although it most certainly has been at some point).

But I would appreciate any help!

I need the ability to select certain check boxes each representing a
certain category and then upon pushing a separate button (Perhaps
titled “GENERATE DATA”) the stats for the selected categories appear in
new sheets as a graph.

I have desperately tried using Macros to do this but can’t figure it
out.

Here is an image of something my boss gave me depicting how he wants it
to work...

http://i187.photobucket.com/albums/x...HubC350145.jpg

I’m sure this is a confusing question so I would be happy to clarify
upon request!

Thank you!!!




--
SweetTea023
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,203
Default Check Box and Button Macros

I think that the reason no one has responded until now is that the question
itself is not so confusing, but that the answer has the potential for being
very complex.

Essentially, all of this code in your macros (and I presume you created them
by recording them?) is going to have to be called by the routine that gets
started when you click your [Generate Data] button.

Some of this depends on where your checkboxes and buttons a on a regular
spreadsheet or within a UserForm. And the details of things depends on the
details of your workbook in general.

I'd be happy to try to help you get started, by seeing your workbook, but it
must be understood that I cannot take on a big project, especially one for a
company, without some formal agreements between us. Little tips, hints, and
how to get started are one thing - completing a potentially long term project
and then being responsible for maintenance of it is another.

If you want some tips, hints and possibly some 'get started' help, then send
the workbook as an email attachment to me at (remove spaces)
HelpFrom @ JLathamSite .com
and I'll see what I can do.


"SweetTea023" wrote:


I have a quick question that I havent seen answered here before
(although it most certainly has been at some point).

But I would appreciate any help!

I need the ability to select certain check boxes each representing a
certain category and then upon pushing a separate button (Perhaps
titled €śGENERATE DATA€ť) the stats for the selected categories appear in
new sheets as a graph.

I have desperately tried using Macros to do this but cant figure it
out.

Here is an image of something my boss gave me depicting how he wants it
to work...

http://i187.photobucket.com/albums/x...HubC350145.jpg

Im sure this is a confusing question so I would be happy to clarify
upon request!

Thank you!!!




--
SweetTea023

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
is it possible 2 macros in 1 check box? HERNAN Excel Discussion (Misc queries) 1 May 15th 08 04:09 PM
Check box macros Sunlover Excel Discussion (Misc queries) 5 January 10th 08 02:28 AM
I need help with macros and check boxes. Marc New Users to Excel 2 March 20th 06 05:20 PM
1 button for 2 macros lunker55 Excel Discussion (Misc queries) 5 June 20th 05 06:25 PM
Macros to delete check boxes GWB Direct Excel Discussion (Misc queries) 23 June 3rd 05 09:56 PM


All times are GMT +1. The time now is 11:10 AM.

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"