Populate ActiveX Combobox with named range

[bonebreaker100]

Hi there.

I am for hours searching an solution but nothing till now. Or it is impossible or I just wasn't able to reproduce what I've sen on my workbook.

So, here it goes:

I've set a named range com a list of banks (on sheet3!) and I want to maintain that way because there is the possibility of add or remove some rows.

On Sheet1! I've a table that I want to filter based on the bank name and, for that, I've an ActiveX Combobox. The problem is not about the filter itself; is how can I define the combobox FillList = to the named range?

Obs: A solution is to select a range like A2:A25 instead of the named range, but I need a way to remove the blank spaces.

Thank you very much for the attention.
Hope someone can help me with this, I need to deliver the project next week and the app design/layout still doesn't exist.

 

[My Aswer Is This]

Assuming you have a Combobox1
And a named Range Named Bank
try this:

Private Sub CommandButton1_Click()
'Modified  10/16/2021  7:10:20 PM  EDT
ComboBox1.List = Range("Bank").Value
End Sub

 

[bonebreaker100]

Good morning

Well, I've tried and I got this error:

I've noticed that you assigned the private sub to "CommandButton1_Click()". Could you please explain why?

I can send the file if you need to understand the problem.

Thank you so much for the help.
Regards,
bonebreaker100

 

[bonebreaker100]

I think that the problem is that I need to say that the named range is on sheet3!

 

[My Aswer Is This]

Good morning

Well, I've tried and I got this error:

View attachment 49209

I've noticed that you assigned the private sub to "CommandButton1_Click()". Could you please explain why?

I can send the file if you need to understand the problem.

Thank you so much for the help.
Regards,
bonebreaker100

Well I just used Command button 1 because thats the command button I put the script in
Copy my script and put it in any button you may want just put this part in the button:

'Modified  10/16/2021  7:10:20 PM  EDT
ComboBox1.List = Range("Bank").Value

 

[My Aswer Is This]

Try something like this then:

Try something like this depending on where the range is:

With ComboBox1
.Clear
.List = Sheets(3).Range("Bank").Value
End With