Combo box help

[miket85]

Hey guys,

I had a question regarding a combo box search function. Ultimately what I am try to accomplish is to have a combo box where the user can which column to search and another box will return the result. It sounds pretty simple right? Currently I have the program running a search function perfectly (user enters a number and the second box displays the related number from column 1), I want to modify it so that it will only search the column they require, so it wont cycle through all the columns.

Let me knwo if you need my code thahnks!!!

 

[miket85]

anyone see anything obviously incorrect with this?? I am a VBA/ programming newb.

 

[kyndig]

Private Sub ComboBox1_Change()

***This part throwing errors***
If ComboBox1.Value = "item 1" Then Set tbl = Sheet169.Range("B").CurrentRegion

ElseIf ComboBox1.Value = "item 2" Then Set tbl = Sheet169.Range("C").CurrentRegion

End If directly after this last line above?

It looks okay. I have never used the .currentregion so don't have any experience to lend you.

 

[miket85]

nope still threw an error but a different one concerning my fnd search function?

 

[miket85]

End If directly after this last line above?

It looks okay. I have never used the .currentregion so don't have any experience to lend you.

i dont have to use current region, if you are aware of any easier way?

 

[miket85]

any other ideas?

 

[miket85]

Ok well i think i have narrowed down my issue. It seems i cannot get my ranges to identify with one column for each if-else statement.