Drop down list/Combo box?
 

Hi
I have a range of cells C6:K6 which contains numbers from 3 to 9.
In a second range C18:K18 I would like to have the following (if possible):

If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box
with values "Yes" and "No".

Can this be done?

Sandy
ps I know I posted this on Public.Excel but I then thought this was a more
appropriate section

Drop down list/Combo box?
 

Check your other post.

Sandy wrote:

Hi
I have a range of cells C6:K6 which contains numbers from 3 to 9.
In a second range C18:K18 I would like to have the following (if possible):

If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box
with values "Yes" and "No".

Can this be done?

Sandy
ps I know I posted this on Public.Excel but I then thought this was a more
appropriate section

--

Dave Peterson

Drop down list/Combo box?
 

I've done so Dave - Thanks

"Dave Peterson" wrote in message
...
Check your other post.

Sandy wrote:

Hi
I have a range of cells C6:K6 which contains numbers from 3 to 9.
In a second range C18:K18 I would like to have the following (if
possible):

If C6 = 3 then C18 = "X" otherwise if C6 3 then Insert a drop-down box
with values "Yes" and "No".

Can this be done?

Sandy
ps I know I posted this on Public.Excel but I then thought this was a
more
appropriate section

--

Dave Peterson