Create drop list on form from range names?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro from active workbook whose name keeps changing 20
Name the range AFTER copied to new sheet 6
Find string from column A in Range("B2:F7") list the header of that column/s 5
Post my named ranges in column A 10
Named Ranges in various sheets 1
Add sheet and name it unless it already exists 12
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
list box remove item by combobox 4

Back
Top