Listbox and Command button

[little_rascals]

Hello, I have two different listboxes. One consists of a
list of tables and the other consists of a list of queries.
By double clicking on the individual table and query, i
can view them.

However, i need to provide 2 different command buttons for
the 2 listboxes. Each command button will be named
as "Import" and it must "recognise" the table or query
selected from the listbox by the user and allow the user
to click and import the correct set of data meant for the
selected table or query from excel files!

 

[Jennifer Hoyte]

If one button applies to one listbox, then when they
click that button, you will know which listbox to look
at. Once you determine which entry is selected, you
would know how to proceed. If you need additional info
about each query/table, you could put that into another
column of the list box but not show it. j.