CuriousGeorg
03-23-2015, 12:51 AM
Good morning,
Im wondering if this is possible. I know it can be done via excel alone or access alone but I need to be able to use both.
What I need is for there to be the data base in Access and then a Userform in Excel.
I will be having a drop down in the userform for the user to select a person and a department. What I want to know is if the user and dept are in an access database is there a way I can use a link between "if user selects department A then x,y,z user appears in the next combobox. IF user selects department b, then a,b,c, user appears in the second combobox etc?
I have done it where the list is in excel an dcan be done using indirect however I need to maintain the list via Access rather than that individual excel spreadsheet
Im wondering if this is possible. I know it can be done via excel alone or access alone but I need to be able to use both.
What I need is for there to be the data base in Access and then a Userform in Excel.
I will be having a drop down in the userform for the user to select a person and a department. What I want to know is if the user and dept are in an access database is there a way I can use a link between "if user selects department A then x,y,z user appears in the next combobox. IF user selects department b, then a,b,c, user appears in the second combobox etc?
I have done it where the list is in excel an dcan be done using indirect however I need to maintain the list via Access rather than that individual excel spreadsheet