Excluding certain columns from a named range while displaying in the Userform Listbox

[znosirovdxb]

Hi All,

I have a data from Column A till Column H. Listbox in the Userform displays the data from a named range "AssessmentRecords" while I type in the textbox "txtID" which is the Column A. Currently, the listbox shows all the data from Column A:H. But I would like to show only Column A:A and relative Column G:H in the listbox.

AssessmentRecords - =OFFSET(Assessment!$A$1,1,,COUNTA(Assessment!$A:$A),COUNTA(Assessment!$A$1:$H$1))

Is there any option to create union of Column A:A and relative Column G:H as one named range and show in the Listbox together as one range? or exclude Column B:F in the Listbox?

Thank you for the response.
Much appreciated.

[jindon]

Easiest way is to hide unneeded columns by setting column width to 0...

eg.

Please Login or Register  to view this content.