I'm having trouble with pairing two sheets.
I have two excel worksheets:
Sheet 1 has keys and Sheet 2 has values.
Is there a way to embed a form on sheet1, that will display the associated values for the keys in Sheet1 pulled from sheet2?
So, if you click on A1 in sheet 1, the form will output the information in A1 sheet2 ? I'd like to have the form embedded on sheet 1,
Example:
Sheet 1 A1 would contain: John
Sheet 2 A1 would contain: John is from Nebraska and is 30 years old, etc., etc., .....(this could be a paragraph of information)
Ideally, when the user clicks on the cell containing john in sheet 1, the form should output: John is from ___ and is 30 years old, from the corresponding cell in sheet2. Both sheets are the exact same size.
I'm new to VBA...Thanks for the help.
I have two excel worksheets:
Sheet 1 has keys and Sheet 2 has values.
Is there a way to embed a form on sheet1, that will display the associated values for the keys in Sheet1 pulled from sheet2?
So, if you click on A1 in sheet 1, the form will output the information in A1 sheet2 ? I'd like to have the form embedded on sheet 1,
Example:
Sheet 1 A1 would contain: John
Sheet 2 A1 would contain: John is from Nebraska and is 30 years old, etc., etc., .....(this could be a paragraph of information)
Ideally, when the user clicks on the cell containing john in sheet 1, the form should output: John is from ___ and is 30 years old, from the corresponding cell in sheet2. Both sheets are the exact same size.
I'm new to VBA...Thanks for the help.
