hamz
12-18-2006, 12:32 AM
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