Drop down list/Combo box?

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

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
 
Check your other post.
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro? VBA? or easier? 3
Copy & Paste cells dependent on value 2
Copy sheet and rename tab 4
Need Advise !.. Is it the best way I found in WorkSheets_Change event 4
Get Month and Year ONLY from cell value 2
Validation fields linked to pivot tables on separate worksheets 2
List sorting and macros 3
Vlookup possibly ? 3

Back
Top