Anusree
10-13-2010, 10:57 PM
Hi,
I have a macro enabled excel sheet. i have a button in sheet2 of this file. My requirement is:
1. when i click on the button in sheet2, i want to create a list which will have the values 'Item1','Item2' and 'Item3' and then i want to place this list in cell A1 of sheet1.
2. when i select a particular value from this list in A1 of sheet1, i want to get the value is selected from this list.
Is there any possible solution for the above. Please help.
Regards,
Anu
I have a macro enabled excel sheet. i have a button in sheet2 of this file. My requirement is:
1. when i click on the button in sheet2, i want to create a list which will have the values 'Item1','Item2' and 'Item3' and then i want to place this list in cell A1 of sheet1.
2. when i select a particular value from this list in A1 of sheet1, i want to get the value is selected from this list.
Is there any possible solution for the above. Please help.
Regards,
Anu