Show only visible cells/rows in Listbox

Originally Posted by romperstomper

Principle is the same, but you did say your listbox was on a userform.

Hello Romperstomper, I know, I did say that.
But at that time I wasn't aware of the possibility to place a listbox on a worksheet.
Now I rather have it on the worksheet