spreadsheet

[miffysnr]

can anyone please help.
i want to create a form using combo boxes which i have done but i also
want to be able to click on the item within the combo box then in
another cell the relevant word or date appears. eg: drop down box
select week 44 and in the other cell the week end appears without
typing it in.
if anyone could help i will be gratful.
miffysnr.

 

[Kevin M]

If you do a dropdown box, the properties of the box allow
you to specify a reference cell. if you've selected the
first item in the box, the reference cell will display a
1. this cell can then be used to reference an IF
statement.
=IF(Ref Cell=1,do something,if(ref cell=2,do something
else etc..
HTH
Kevin M