HELP - how to use VBA to create Dependent List in EXCEL?

I am new to VBA and I am working on a project that needs to use VBA to create Dependent List (drop-down list, Column B value depends on the values selecting from Column A on an Excel template). Can any expert/guru provide some idea for this sample code, or even a useful URL will be greatly appreciated.

Thanks a lot.


Answer this question

HELP - how to use VBA to create Dependent List in EXCEL?

  • Morbo

    Hi Gary,

    This link was suggested by another forum member:
    http://www.cpearson.com/excel/vbe.htm

    If you're still working on this issue and the link above doesn't cover what you're looking for please reply to this post and we'll run your questions by one of our support engineers.

    thanks,
    -brenda (ISV Buddy Team)

  • HELP - how to use VBA to create Dependent List in EXCEL?