Excel vba populate multicolumn listbox from range

Hi All

I have a userform That has Several client information textboxes on it including a textbox called txtClientID.

What I would like to do is add a multicolumn listbox to the form and populate it from a worksheet - "sheet3" Columns B to E. These records would be filtered by the txtClientID textbox (this would correspond to a client ID value in column E).

So I would have a listbox that contained all the records from Sheet 3 that relate to the Client ID on the userform.

Any help would be much appriciated.

JP

You can go anywhere you want if you look serious and carry a clipboard.

Re: Populate Multicolumn Listbox

The .List property is one way.