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
 

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