Thread: Userform
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Tikken Paul Tikken is offline
external usenet poster
 
Posts: 25
Default Userform

I'm using different columns as a source for my listboxes of my userform. I've
set the range for each independent column. But these ranges may vary, because
of inputs into the userform. How can I make the listboxes adjust to these
flexible ranges?

So let's day that for column J, I've set the range from J1:J4092, but this
entire range is not filled so I only want to display the used range in column
J.

Is this possible?

Paul