bassnsjp
08-22-2009, 04:28 PM
I'm using MS Windows XP Pro and MS Office 2003. Here is an example of a system configuration worksheet. The worksheet is designed to track the configuration levels of various components of particular systems, in this example, the ISUN system is used. I Don't know how to insert multiple spaces or tabs so I'm using hypens ("-") in place of.
System---NDI Configuration
ISUN-----ISUN-NDI-AA-03.00
The configuration level represents the products that consititutes that particular level, which is at least one product, but usually represents many different products. Here is an example of the ISUN-NDI-AA-03.00 configuration to product worksheet.
Configuration---------Product
ISUN-NDI-AA-03.00-- MS Windows XP Pro
ISUN-NDI-AA-03.00-- MS Office 2003
ISUN-NDI-AA-03.00-- Adobe Reader 8
ISUN-NDI-AA-03.00-- Norton Utilities 14
Both worksheets exists in the same workbook. What I would like to do is click on the cell in the system configuration worksheet that contains ISUN-NDI-AA-03.00 and have a script activated to read the current active cell and search the product configuration worksheet and display all the products that are associated with that particular configuration level. Is there a way to click on the contents of a cell to activate the execution of a script/macro? Any assistance would be greatly appreciated, thank you in advance.
System---NDI Configuration
ISUN-----ISUN-NDI-AA-03.00
The configuration level represents the products that consititutes that particular level, which is at least one product, but usually represents many different products. Here is an example of the ISUN-NDI-AA-03.00 configuration to product worksheet.
Configuration---------Product
ISUN-NDI-AA-03.00-- MS Windows XP Pro
ISUN-NDI-AA-03.00-- MS Office 2003
ISUN-NDI-AA-03.00-- Adobe Reader 8
ISUN-NDI-AA-03.00-- Norton Utilities 14
Both worksheets exists in the same workbook. What I would like to do is click on the cell in the system configuration worksheet that contains ISUN-NDI-AA-03.00 and have a script activated to read the current active cell and search the product configuration worksheet and display all the products that are associated with that particular configuration level. Is there a way to click on the contents of a cell to activate the execution of a script/macro? Any assistance would be greatly appreciated, thank you in advance.