UserForm -> Combobox and it's RowSource property?

**CEC** · 03-23-2011, 03:09 PM

Hi guys,

Facts:
I created a userform and in it, I have a combobox. In its properties, there's an item (RowSource) which allows you to let the user pick from a list (my list, in this case is a range called HR_Reps within the workbook). Basically, when clicking on the dropdown(combobox), you get a list of HR Representatives. The RowSource works fine while the Range is within the workbook.

Challenge:
I'm trying to put a range from a different file in RowSource...

1 - Don't know the format
2 - Is it even possible to do it?

Let me know what you think...and thanks!

Alex

**jwright650** · 03-23-2011, 03:28 PM

Alex, can you post an example of your workbook?

There are a couple of ways to fill the combobox/listbox...post up your example so we can see which method may work best for you.

**CEC** · 03-23-2011, 03:38 PM

Ah, I figured it out.

In a nutshell, I had to do it in VBA because I couldn't do it from the property by changing RowSource. This would be a sample of what my code looks like.

---------------------------------------------------
Private Sub UserForm_Activate()

' Updates ranges to reference file.

With UserForm1
.ComboBox1.RowSource = ("'L:\Folders\[Reference List.xls]Sheet1'!MyRange")
End With

End Sub

**watersev** · 03-23-2011, 03:38 PM

hi, CEC, if another workbook is open it works fine. format:

Please Login or Register  to view this content.

Xl0000115.xls - file name of open workbook
Data - sheet name

If the workbook is closed a full path needed.

**CEC** · 03-24-2011, 09:08 AM

Originally Posted by watersev

hi, CEC, if another workbook is open it works fine. format:

Please Login or Register  to view this content.

Xl0000115.xls - file name of open workbook
Data - sheet name

If the workbook is closed a full path needed.

In my case, it wouldn't be practicle. The main file will be distributed to hundreds of users...it's why I needed a remote range so I can only update 1 file (and not all hundreds of them) every time a representative comes/goes. Opening the file would turn it Read Only and then other users wouldn't be able to use it for that brief moment.

The VBA methods works pretty good for me. Thanks though.

**ankur3020** · 07-30-2013, 02:37 AM

Pls help me in linking my excel sheet named training to combobox1 in userform of QKB sheet. i want when userform is load in QKB, it display data of training sheet in combobox1.

**arlu1201** · 08-02-2013, 02:16 PM

ankur,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.