eti3nne
MIS
- Feb 5, 2004
- 102
I have an excel spreadsheet which contains 3 lists on the same page, side by side. I have selected any one of the lists and clicked on Data ... Form .. and I am able to add or delete entries in the correctly selected list.
I want to be able to just click on one of 3 buttons (one per list) and have the selected list pop up in the form. I have recorded a macro when doing this manually, but when I put this into the code behind my button, the form always picks up the left most list. How do I force the form to link to the correct list?
Any ideas?
Thanks for looking.
I want to be able to just click on one of 3 buttons (one per list) and have the selected list pop up in the form. I have recorded a macro when doing this manually, but when I put this into the code behind my button, the form always picks up the left most list. How do I force the form to link to the correct list?
Any ideas?
Thanks for looking.