ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Combo Box (https://www.excelbanter.com/excel-worksheet-functions/145241-combo-box.html)

Donovan[_2_]

Combo Box
 
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?
--
dmccoy

[email protected]

Combo Box
 
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


On Jun 5, 8:56 am, Donovan wrote:
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?
--
dmccoy





All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com