Pull down menu in Mac office excel

[shaun collier]

Hi all,
I want to produce a user friendly form for my employees. For example if you
went to cell a:1, you could click on a button and a list appears. Then onto
cell a:2 another button with another drop down list etc.nothing over the top
really maybe a matrix of buttons and pull down lists for example about 20
cells by 20 with drop down lists. Is excel the program to use, in windows xp
'access' looks best bet but mac office doesn't have it......help me
please...going nuts typing in repeat text after repeat text to produce
electrical test results

Regards
Shaun

 

[Bob Greenblatt]

Hi all,
I want to produce a user friendly form for my employees. For example if you
went to cell a:1, you could click on a button and a list appears. Then onto
cell a:2 another button with another drop down list etc.nothing over the top
really maybe a matrix of buttons and pull down lists for example about 20
cells by 20 with drop down lists. Is excel the program to use, in windows xp
'access' looks best bet but mac office doesn't have it......help me
please...going nuts typing in repeat text after repeat text to produce
electrical test results

Regards
Shaun

Have you tried cell validation? You can create a list that will be used when
the cell is selected. If you want the same list for several cells, either
copy the cell and paste it to other locations, or use the fill handles to
drag the cell around to where it is needed.

 

[little_creature]

Have you tried cell validation? You can create a list that will be used when
the cell is selected. If you want the same list for several cells, either
copy the cell and paste it to other locations, or use the fill handles to
drag the cell around to where it is needed.

Hello,
What about Forms? Open Forms toolbar (tools>customize>toolbars>forms).
There are different buttons such as combo box. Draw the button and
double click on it, you can set area from which will the list be
created (you can put in in z colum ad hide it, su just the buttons
will be wisible for the emplyes). You might also assign macro to these
buttons. Have a try.