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