Userform Combobox List from another workbook

[KAOS137]

Hello,

I have a user form stored in my personal macro workbook. It has a combobox that uses a named range as it's rowsource. This named range is located on Sheet 1 of my personal macro-book.

What I want to do is open the userform on another open workbook with the personal macrobook hidden and have the combobox drop-down list display the named range.

It works fine in the personal macrobook but when I call on the useform from another workbook the list disappears. Any guidance? Is this possible?

 

[Norie]

How is the named range defined and how are you setting it as the source for the combobox?

Also, where is the userform located? The workbook you are opening or in the personal workbook?

 

[KAOS137]

The named range is "CLINIC"( I hope that is what you mean by defined?) and I have put this directly in the RowSource section of the combobox properties panel

The userform is located in the personal workbook as I want to use the named ranges on many work workbooks.