I can make the combo box but how do i fill it with the possible values and select the cell it is linked to.
There are 2 types of controls in Excel
The controls available from
1) Forms Toolbar
2) Control Toolbox
The 1st one you cannot cahnge the Text font
The 2nd one you can, via right click then
select properties.
In the properties list look for Font and change
it here.
If your Control toolbox is not visible then
select it via right clicking anywhere on your
commandbar and select Customise.
In the dialog box select ToolBars tab and
look for the Control Toolbox.
HTH
Ivan
i'm not good in english..but i try..
first u have to use the combobox from
the control toolbox and from the form.
do u get in..
and second while u r in design mode,
via clicking right, u will find properties.
in properties, u will find the linked cell
n the list data..sorry..if u not u/stand.i'm just
try to help.sorry for my poor english
I can make that one but not sure how to set it up
Which part of the setup are you not sure of ??
Have you got the combobox from the Toolbox ??
Please advise.