View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wayne Wayne is offline
external usenet poster
 
Posts: 133
Default Can you load part of a worksheet into a userform

I have 2 columns on a worksheet which include a list of default values. What
I want to do is allow people to add to the list - but I would like to do this
in a user form for 2 reasons 1 - almost everything else they do is through
user forms and 2 I want them to see only the columns that contain the
information they need. Columns B and E.

I could do this by protecting the shet and hiding all other columns - but
would like to make it neater, by displaying the range of cells, or both
columns on a user form.

Is this possible?
wAyne_