Cell Formula to filter combobox data into cell

[Patriot2879]

Hi, good afternoon I would like to copy what is highlighted in my combobox which is in my userform1 i have tried the formula below which i have put in cell M1 but it doesnt pick up anything from the combobox can you help me please?

=filter!UserForm1 ("ComboBox1")

 

[Momentman]

So you have a UDF(user-defined function) that extracts data from the Userform? is that?

If you need to just have the value of the combobox in cell A1, you could simply do

Range("A1").Value=Userform1.ComboBox1.value

 

[Patriot2879]

hi do i put that into the cell where i want the data found to go? Or do i put that into the combox1?

 

[Momentman]

hi do i put that into the cell where i want the data found to go? Or do i put that into the combox1?

It all depends on how your userform is set-up. If the cell you want to copy to is already active, you can have an OK button on the userform that when you click will copy the selected value to the cell

 

[Patriot2879]

Hello what I would like is in my sheet called 'filter' is to copy what is highlighted in my combobox1 in userform1. If you can advise please

 

[Momentman]

So you have a UDF(user-defined function) that extracts data from the Userform? is that?

If you need to just have the value of the combobox in cell A1, you could simply do

Range("A1").Value=Userform1.ComboBox1.value

Thats what i suggested here

You can have an OK button on the userform and place that line of code in there, so when you click the OK button, the selected value in the combobox is copied to cell A1

Worksheets("Filter").Range("A1").Value = Userform1.ComboBox1.Value

or

Activecell.Value=Userform1.ComboBox1.Value

if you want it to copy to the activecell

 

[Patriot2879]

Hi sorry I'm still new to this. Where do I put the activecell? I didt want another button but just to copy over to the cell automatically. Thanks for the help

 

[Momentman]

Double click the combobox on the userform to open the code behind

You can paste a code like this in there

Private Sub ComboBox1_Change()
    Worksheets("Filter").Range("A1").Value = Me.ComboBox1.Value
End Sub

Whenever the combobox changes, the value in A1 changes, so maybe if you are specific about what cells you want the value copied to, we can write specific codes for what you want

 

[Patriot2879]

Hi thanyou for your help this works great much appreciated for your time