Data Validation boxes

[Roger_H]

Hello

I am designing a spreadsheet that needs to be as simple as possible.
It will downloadable from a company extranet site and needs to be
absolutely dummy proof.

To this end I need :

1. Data lists/Dropdown boxes, which contain user defined optional data,
with all of the options in the dropdown visible to the user, without
the user having to activate the dropdown list itself (by pressing the
dropdown button to the right of the cell).

2. On inputting data, when the user completes a particular field
pressing enter will automatically take them to the next required data
input field.
I know that this is possible by protecting cells other than the
required input fields and then tab-ing thru, but I need it to
specifically work when 'Enter' is pressed.

Any help greatly appreciated

Cheers

Rog

 

[Earl Kiosterud]

Roger,

1. I don't know of a way to get a dropdown automatically upon selecting a
cell. I think you'll have to build your own listbox (Controls Toolbox), and
write some code to make it appear when the user goes to the column, cells,
whatever.

2. You can set the EnableSelection property of the sheet to xlUnlockedCells:
In the VBE, have the sheet selected in the Explorer window, and the
properties window open. There you can change it.

Or use this code:
Sheets(1).EnableSelection = xlUnlockedCells

Then protect the sheet (either solution).

Earl Kiosterud
mvpearl omitthisword at verizon period net