Form Control Question

J

jeff

Hi,

Why not use Data Validation? You can select all your
target cells in the payment type column, then Menu>Data>
Validation... select "list", point to your list of types,
and OK.

Each cell then uses your selections.

jeff
-----Original Message-----
How do I link a form control list box to multiple
Click to expand...
cells? For example, I have a column labeled payment type
and I want the user to choose from a list containing
check, cash, credit card. However, when I put the list
box in it only allows me to link it to one cell? Do I
have to create a new form control for each cell? There
must be an easier way to do this......help.
 
A

AlfD

Hi!

To get various cells to respond according to the value in the linke
cell:

Linked cell is A1
Values it can hold are 1 to 5
B1 to F1 hold =if(A1="1","My turn","")
...................... =if(A1="2","My turn","")
etc

But I'm not sure why you would want to do this. The value in you
linked cell is well-suited to being an input to a VBA routine (e.g
using Select Case).

Al
 
Top