Could not set the RowSource property. Invalid Property Value error when switching between excel files

[sathyaganapathi]

Hi,
I am using VBA to store and get the data from Access database using Userforms.
I used drop down and sub dropdown comboboxes for selection of items. 'Select case' option is used for better control of the comboboxs.
The Rowsource data for both comboboxes are from 'name manager' defined in the same excel workbook.
Combobox style is set to dropdowncombo.

The problem is, when I switch between excel workbook and come back to main workbook where userform is running, I get the error while clicking on the listbox line item to select and edit.
The application closes and again we have to start the macro. This happens only when we switch between workbook and come back.
If we continue work with same workbook it works fine.
Please somebody help to get rid of this.

 

[sathyaganapathi]

Dear RoryA,
Thanks a lot for your inputs.
Looks fine in the test workbook. Let me apply this to the original file and check with actual use. I will let you know after checking..

 

[sathyaganapathi]

I don't need to see the workbook. You just need to use the same syntax you would in a formula - for example:

'workbook name.xlsm'!Department

Dear RoryA,
It is working fine in the original file too. Thanks a lot for your suggestion..
Have a good day..