visual basics

conorot

Hi i have a vb question for drop down menus,
its to do with RowSource, i know you put in the name of the Row from a specific work sheet pre selected but i have a menu system that where it should depend what worksheet you are using that would determin what row to select (THE WORKSHEETS AND ROW NAMES FROM THE WORKSHEET ARE THE SAME), so the RowSource is not the same all the time for each worksheet its used on, is there a way to set it to the current worksheet from the RowSource section in properties?

No point in doin Worksheets("example") or anything llike that with the code, its massive.

conorot

or is there a way of selecting multiple rows into RowSource like

test1!test2 but the ! will give the the row of test2, is there a way to do a & or something?

conorot

nevermind, i figured it out, i just copied a few of the interfaces i did out and changed the RowSource for each one and called each one where they should have been called!
Thanks anyways for all who put some thought into this.