show info from access in excel

[miiia83]

hi!

Is it possible to make a scrolldownlist in excel that contains info from a table in access..? And then if you choose "C" from the list the info that belongs to "C" should appear??

Mia

[antoka05]

You can use this code code to populate a listbox with data from access
(to use the code open VB editor (alt + F11), click on menu tools, select reference, from the list select 'Microsoft DAO 3.xx Object Library):

Please Login or Register  to view this content.

Regards,
Antonio

[miiia83]

I didn't get that to work... not that good at VB

[miiia83]

this is the code that I have... it only shows the info from function_code and description..
I want the FUNCTION_CODE to be shown as an listbox.. and then when you choose "1H" out of the listbox.. then DESCRIPTION should show the info that belongs to "1H".
Did that make any sence??

Please Login or Register  to view this content.

Mia

[miiia83]

Nobody knows??