Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Values
Hi,
I'm new to all this Excel programming. I have a spreadsheet with two worksheets. On the first page is a combo box and I would like to box to display values from the second page i.e. B4 to B24. I think the array function is involved but I'm having trouble referencing to the second page. Can someone please help me with the code? Cheers, D |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Values
Assuming this is a combo box from the Controls Toolbox:
Name the range b4:b24 "myrange" Like this: Insert/Name/Define - type in myrange - Refers To: =Sheet2!$B$4:$B$24 Right click the combo box / Properties / In the ListFillRange type myrange "Oconneld" wrote in message ... Hi, I'm new to all this Excel programming. I have a spreadsheet with two worksheets. On the first page is a combo box and I would like to box to display values from the second page i.e. B4 to B24. I think the array function is involved but I'm having trouble referencing to the second page. Can someone please help me with the code? Cheers, D |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Values
(still assuming a combobox from the control toolbox toolbar on a worksheet
as Don has assumed) .. . . or Right click the combo box / Properties / In the ListFillRange type Sheet2!$B$4:$B$24 -- Regards, Tom Ogilvy Don P wrote in message ... Assuming this is a combo box from the Controls Toolbox: Name the range b4:b24 "myrange" Like this: Insert/Name/Define - type in myrange - Refers To: =Sheet2!$B$4:$B$24 Right click the combo box / Properties / In the ListFillRange type myrange "Oconneld" wrote in message ... Hi, I'm new to all this Excel programming. I have a spreadsheet with two worksheets. On the first page is a combo box and I would like to box to display values from the second page i.e. B4 to B24. I think the array function is involved but I'm having trouble referencing to the second page. Can someone please help me with the code? Cheers, D |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box Values
I have a webpage devoted to this topic:
ListBox and ComboBox controls in Excel www.rubbershoe.com/listbox.htm Tim Zych "Oconneld" wrote in message ... Hi, I'm new to all this Excel programming. I have a spreadsheet with two worksheets. On the first page is a combo box and I would like to box to display values from the second page i.e. B4 to B24. I think the array function is involved but I'm having trouble referencing to the second page. Can someone please help me with the code? Cheers, D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform Initialize & combo box values | Excel Discussion (Misc queries) | |||
Values to Combo Box | Excel Discussion (Misc queries) | |||
Populate combo box with unique values only | Excel Discussion (Misc queries) | |||
Combo Box Values not Numbers | Excel Worksheet Functions | |||
Combo Box Values from Access Table? | Excel Discussion (Misc queries) |