Thanks I think this will work but I have an additional question, I've never
used viisual basic code with excel, how do I apply this code to a certain
cell or pull down list?
Take note of where Debra's DV dropdowns are located then look at the event
code behind the sheet to see where you should make changes to ranges.
If you downloaded the workbook you will see Debra has included 5 sheets.
One of these is "Lists" where the DV source lists are housed and is common
to all.
The other 4 sheets are examples of different types of returns......comma
separated, same cell etc.
Which of these would you want to use?
Where would your DV dropdowns live?
Gord
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.