-Create a ComboBox.
VIEW / TOOLBARS / CONTROL TOOLBOX
Select 'Combo Box'. Go to where you want to put the box. Left-click and
hold it while drawing a rectancle the size of the box you want. On the
toolbox, click on the 'Properties' button. In the 'LinkedCell' property,
put a cell address such as A5. This is where the selection you choose from
the box will appear. In the 'ListFillRange' property, put the address of
the list of items you want to select from. For example, in cell F1 put
'
http://www.MSN.com', F2 put '
http://www.cpearson.com', F3 put
'
http://www.j-walk.com'. Now in the 'ListFillRange' property put F1:F3. If
your list is on another sheet, use syntax like Sheet4!F1:F3.
Next, select the 'Exit Design Mode' on the toolbox. Close the toolbox.
In B5 put the following formula...
=HYPERLINK(A5)
To make it a bit more sophisticated, in E1 put 'msn', E2 put 'Chip', in E3
put 'John'.
In the 'ListFillRange' property put E1:F3. In the 'BoundColumn' property
put 2. (This means, put the information from the 2nd column of the range
into A5.) In the 'ColumnCount' property put 2. (Letting the combobox know
that there are 2 columns.) In the 'ColumnWidths' property put 50;0. (This
says to make column E 50 pixels wide and column F -0- pixels wide - i.e.
invisible so all you'll see is msn , Chip and John in the list).
Enjoy.
Gary Brown
