Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible 2 macros in 1 check box? | Excel Discussion (Misc queries) | |||
Check box macros | Excel Discussion (Misc queries) | |||
I need help with macros and check boxes. | New Users to Excel | |||
1 button for 2 macros | Excel Discussion (Misc queries) | |||
Macros to delete check boxes | Excel Discussion (Misc queries) |