Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using a combobox on 1st sheet in a worbook, how can I use it to display data
in a column from sheet 2 in the same workbook?
 
Donovan

Give the area of sheet2 that you want to include in the combobox
display data a range name, for example "data", then make "data" the
ListFillRange for the combobox on sheet1, but, editing the properties
box for the combobox.

Good luck.

Ken
Norfolk, Va
 
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

Excel Move or Copy Stopped Working? 0
Cross Reference 2 columns in seperate workbooks 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
data consolidation 1
Need combo box to refresh when moving to new record 2017 1
Choosing which sheet opens 1
Formatting problem copying sheet 3
Comparing 2 worksheets in Excel 2007 1

Back
Top