combobox

[hamz]

Good day VB experts!I have a problem on my current VBA excel. There are 2 columns that a user wants to select or type to search. Column A contains partcodes and ColumnB contains partnumbers. What codes to use when an optionbutton1 clicks the combobox rowsource is that of columnA and when optionbutton2 clicks the Rowsource is that of column B.Also pls consider the user to type on the combobox to whatever he wants to search.Thanks.Hamz

[Bob Phillips]

[vba]

Private Sub OptionButton1_Click()
ComboBox1.RowSource = "A1:A10"
End Sub

Private Sub OptionButton2_Click()
ComboBox1.RowSource = "B1:B10"
End Sub
[/vba]

[Petrogeo]

Check if it will help you: http://www.vbaexpress.com/kb/getarticle.php?kb_id=824 , there?s a file attached.

rgds