View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default Create drop list on form from range names?

I have single-row item entries on the front sheet, with each one named as a
separate range. Each item will then be tracked on a separate sheet, with
values and such showing up on the front sheet. I'd like to use a Form to
set an action and quantity for the individual item.

Is it possible to open a UserForm that will list all the ranges - whether 2
or 20 - as check or option boxes, and for each range give text boxes to
allow input?

Ed