Hi again,

next 2 problems i'm struggling with in vba.

Problem 1:
I would like for a cell(A1) to have a dropdownmenu just like a validated
cell, but the list is in a different worksheet of the same workbook.(for
example: sheet2 range $B$B)

Problem 2:
The menu provided have to have the abbility to add new items to that list.

Does anyone have an idea?

Regards,
Peter