Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Populate embedded combo box
Hi, does anyone know how I populate an embedded combo box (from the control toolbox) with data. FURTHER INFO The data I wish to populate the combo box with is containined within the same spreadsheet as the data. thanks in advance for any help. -- Jahunga ------------------------------------------------------------------------ Jahunga's Profile: http://www.excelforum.com/member.php...o&userid=15291 View this thread: http://www.excelforum.com/showthread...hreadid=314422 |
#2
|
|||
|
|||
Hi
why not use 'Data - Validation'? "Jahunga" wrote: Hi, does anyone know how I populate an embedded combo box (from the control toolbox) with data. FURTHER INFO The data I wish to populate the combo box with is containined within the same spreadsheet as the data. thanks in advance for any help. -- Jahunga ------------------------------------------------------------------------ Jahunga's Profile: http://www.excelforum.com/member.php...o&userid=15291 View this thread: http://www.excelforum.com/showthread...hreadid=314422 |
#3
|
|||
|
|||
Jahunga,
with the design mode on the control toolbox selected, right click the combo box, select properties fromt he shortcut menu, and scroll through the list until you find list fill range. Enter the range containing the data you want to select from. Steve "Jahunga" wrote in message ... Hi, does anyone know how I populate an embedded combo box (from the control toolbox) with data. FURTHER INFO The data I wish to populate the combo box with is containined within the same spreadsheet as the data. thanks in advance for any help. -- Jahunga ------------------------------------------------------------------------ Jahunga's Profile: http://www.excelforum.com/member.php...o&userid=15291 View this thread: http://www.excelforum.com/showthread...hreadid=314422 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with embedded pdf file | Excel Discussion (Misc queries) | |||
Drop down list or combo box help needed | Excel Discussion (Misc queries) | |||
Combo box copy data | Excel Discussion (Misc queries) | |||
combo box formatting | Excel Discussion (Misc queries) | |||
How to populate column with formula based on value in cell | Excel Worksheet Functions |