Displaying a sheet on a userform

[fraz627]

Is it possible to display a part of a sheet on on a userform. I would like to use it like a list box, and have the option of filtering data.

Thanks

 

[Rhodie72]

I think thats going to head into js territory with dynamic link library calls from compiled code. Other more experienced members amy have a better solution

 

[My Aswer Is This]

You can put a part of a sheet into a control on a userform with something like this:

ListBox1.List = Range("A1:A20").Value