harpreetgujral
New Member
- Joined
- Oct 30, 2010
- Messages
- 6
Hello everybody,
I am facing the following issues while working with Excel ADD_INs
1) i have designed an automation which makes allows the user to access the full Macro through a Excel ADD_IN
2) i have used a couple of forms in the the ADD_IN, which are saved in the ADD_IN file
3) The forms used have a couple of Drop_Down Boxes, in order to fill up these boxes with the Data, i am unable to pull data from the Excel ADD_IN file itself, so as a turnaround, i saved the data into another Excel file.
At present, i call the new excel file to open and then show the form to the user, this way i am able to populate the Drop Down Boxes placed on the Form present in the ADD_IN with the right data.
Is there a way to fill these Drop Down Boxes with the data i want the user to view from the ADD_IN file itself? [If there is an sample file, then please send it, i can replicate the concept from that ]
Thanks in advance
I am facing the following issues while working with Excel ADD_INs
1) i have designed an automation which makes allows the user to access the full Macro through a Excel ADD_IN
2) i have used a couple of forms in the the ADD_IN, which are saved in the ADD_IN file
3) The forms used have a couple of Drop_Down Boxes, in order to fill up these boxes with the Data, i am unable to pull data from the Excel ADD_IN file itself, so as a turnaround, i saved the data into another Excel file.
At present, i call the new excel file to open and then show the form to the user, this way i am able to populate the Drop Down Boxes placed on the Form present in the ADD_IN with the right data.
Is there a way to fill these Drop Down Boxes with the data i want the user to view from the ADD_IN file itself? [If there is an sample file, then please send it, i can replicate the concept from that ]
Thanks in advance