Hi all,

I am struggling on my project, and I am new to excel. I need help in:

how to copy a range (L7:L149) that is mark with 'x' range(I7:I149) from sheet 'summary' and paste on to another sheet 'information' userform - combobox1? so that I can search base on the one that is paste on the combobox1.

Note: Only copy the range that is marked with 'x', which meant only one is selected and copied to the combobox1, so that I can search only one.

Thanks a lot!!