L
Lisa12
How do I format a cell so a user can *only* choose from a drop-down box, but
can not enter into the cell?
Thank you,
Lisa12
can not enter into the cell?
Thank you,
Lisa12
P
Pete_UK
Select the cell then click on Data | Validation and on the pull-down
for Allow select List. If you just have a simple restricted list like
A, B, C, D then you can enter this directly into the Source box with
each item separated by a comma. If your list is more complex, then in
the Source box you should put a range that refers to where your list
is, e.g.:
=$D$1:$D$10
if you have a list of acceptable items in the cells D1
10 of the same
worksheet.
If your list is on another worksheet you will need to give the range a
name, eg "source_data", and then you can enter this named range in the
Source box.
Click OK when you are finished.
Hope this helps.
Pete
for Allow select List. If you just have a simple restricted list like
A, B, C, D then you can enter this directly into the Source box with
each item separated by a comma. If your list is more complex, then in
the Source box you should put a range that refers to where your list
is, e.g.:
=$D$1:$D$10
if you have a list of acceptable items in the cells D1
10 of the sameworksheet.
If your list is on another worksheet you will need to give the range a
name, eg "source_data", and then you can enter this named range in the
Source box.
Click OK when you are finished.
Hope this helps.
Pete
L
Lisa12
I have created the drop-box and attached the list, but I am trying to protect
the cell so a user can only use the drop-box. In other words they can't even
attempt to enter an incorrect item causing a stop. I don't even want them to
be able to enter the cell just the drop-box.
Thank you,
Lisa
the cell so a user can only use the drop-box. In other words they can't even
attempt to enter an incorrect item causing a stop. I don't even want them to
be able to enter the cell just the drop-box.
Thank you,
Lisa
P
Pete_UK
I don't understand - the drop-down box is integral with the cell, when
selected. If the cell was protected, then the value could not be
changed.
Pete
selected. If the cell was protected, then the value could not be
changed.
Pete
K
Ken Johnson
A ComboBox would be prefect.
Ken Johnson
S
Spiky
Well, it would be nearly perfect. Except that it also must be linked
to a cell, and THAT cell cannot be locked, either.
I find the best way is still a ComboBox since the validation is
stronger. Put its linked cell out of the way, in a hidden row or
column. When you lock the sheet, they won't be able to find it to do
damage. You can still reference the hidden cell.