data entry

[Stella]

I want to send a template to a customer which they fill in with ease. here
what i want it to do....any help is appreciated.

Trader Name Operating System Software Version
Exchange1 Exchange2
options e.g. Joe Bloggs XP 2.6.1.18
check box check box
2000
2.6.1.19 check box check box
NT 4
2.6.1.20 check box check box
ME
2.6.1.6 check box check box

when the customer gets to the operating system & software versionn column, a
drop down menu shud appear. similar they should be able to choose whether or
not they use a particular exchane or not.

TRICKY BIT - i only want the options like the drop-down menu to appear if
the customer starts to type something in that row. pretty much like ms
access.

pls help!

Thanks,
Stella

 

[Dave Peterson]

Instead of having the dropdown appear when they start a new row, how about using
Data|Validation.

The arrow in those cells doesn't appear until the cell is actually selected.
And you could apply the save data|validation rules to the whole column.

You can find a lot of info about data|validation at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

 

[Debra Dalgleish]

You can use Data>Validation to create a dropdown list. It's not exactly
like a combobox in Access, but may be close to what you want.

There are instructions in Excel's Help files, and here:

http://www.contextures.com/xlDataVal01.html