Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Varibles determine macro to run
I have searched the forum for a clue to answer my own question with n luck. I am a novices compared to all of you. I have parts spareing work book that creates a recommended parts lis that people need depending on how many units they support and th model. I wanted to be able to look at three fields on top level sheet and us this to select a macro to filter my data sheet, by the inputs and the print a report of the parts they need. I have the calculations worked out for the numbers. I have two control buttons that will determine the level of parts Basi or ALL. THis is a matrix for how I will filter based on the button selected an the varibles I find in cells D8, D9 and D11. Combinations for all inputs. Note numbers will be 0 or 0 used 1 fo simplicity. D8 D9 D11 Detail Basic Run 1 0 0 1 0 Macro1 1 1 0 1 0 Macro2 1 0 1 1 0 Macro3 1 1 1 1 0 Macro4 0 1 0 1 0 Macro5 0 0 1 1 0 Macro6 0 1 1 1 0 Macro7 1 0 0 0 1 Macro8 1 1 0 0 1 Macro9 1 0 1 0 1 Macro10 1 1 1 0 1 Macro11 0 1 0 0 1 Macro12 0 0 1 0 1 Macro13 0 1 1 0 1 Macro14 * * * 0 0 ERROR * * * 1 1 ERROR 0 0 0 * * ERROR Thanks in advance for any thoughts -- Dennis Lavalle ----------------------------------------------------------------------- Dennis Lavallee's Profile: http://www.excelforum.com/member.php...fo&userid=3457 View this thread: http://www.excelforum.com/showthread.php?threadid=54346 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Varibles determine macro to run
Thanks, I'll try it today. Again Thanks: -- Dennis Lavalle ----------------------------------------------------------------------- Dennis Lavallee's Profile: http://www.excelforum.com/member.php...fo&userid=3457 View this thread: http://www.excelforum.com/showthread.php?threadid=54346 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Varibles determine macro to run
Ardus, I thank you for getting me going works like a champ. Thank -- Dennis Lavalle ----------------------------------------------------------------------- Dennis Lavallee's Profile: http://www.excelforum.com/member.php...fo&userid=3457 View this thread: http://www.excelforum.com/showthread.php?threadid=54346 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Varibles determine macro to run
Thanks for the feedback!
Cheers, -- AP "Dennis Lavallee" <Dennis.Lavallee.2825qn_1148047804.6819@excelfor um-nospam.com a écrit dans le message de news: ... Ardus, I thank you for getting me going works like a champ. Thanks -- Dennis Lavallee ------------------------------------------------------------------------ Dennis Lavallee's Profile: http://www.excelforum.com/member.php...o&userid=34572 View this thread: http://www.excelforum.com/showthread...hreadid=543463 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can you let macro determine to where to copy | Excel Discussion (Misc queries) | |||
Use Combo Box value to determine macro used | Excel Worksheet Functions | |||
Making a graph with 3 independant varibles | Excel Discussion (Misc queries) | |||
Excel Pivot Tables-How to put two Data Varibles side by side | Excel Worksheet Functions | |||
declaring varibles looping probelm | Excel Programming |