Excel 2007 Combobox data referencing to table names using user form VBA

  • Hi all,


    I'm looking for a possibility to get data from a table name into the combo box.


    So this is what the data looks like


    I've got in A1 a Text Value that references on a table name.


    This table has eg. 10 different entries for part names that should be listed in the user form combo box.


    The value then selected has to be written automatically in B1.


    Thanks for your support.


    MrT

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!