Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creatiing a Combo box (ActiveX)
Hi
I would like to know how to create a combo box (ActiveX) I've selected "combo box" from the "Control tool Box", but I do not know how to insert the data I want to be displayed Does anyone has an example Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creatiing a Combo box (ActiveX)
make the control toolbox visible. the upper left icon (with the drawing
triangle) should be depressed (and remain depressed) to put you in design mode. Right click on the combobox and select properties. If on a worksheet, you want the listfillrange, and if on a userform, RowSource. Type in your source range Sheet1!A1:A20 as an example. -- Regards, Tom Ogilvy "Al Norka" wrote in message ... Hi, I would like to know how to create a combo box (ActiveX). I've selected "combo box" from the "Control tool Box", but I do not know how to insert the data I want to be displayed. Does anyone has an example? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert a list in the ActiveX combo box | New Users to Excel | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Activex combo box won't display values | Excel Programming |