Create a Drop Down list if another cell meets certain criteria

**rini11** · 09-18-2013, 02:57 AM

Hi

I would like cell D7 to display a drop down list (already set on another worksheet Name = POSITION) if cell S4 >1

I have tried =if($s$4>1,position) but this is not working

thanks

**FDibbins** · 09-18-2013, 02:59 AM

do you mean that if S4 <= 1, then there should be no D/D?

**rini11** · 09-18-2013, 03:09 AM

if S4<+ 1 then no drop down list and display blank

**rini11** · 09-18-2013, 03:10 AM

oops S4<=1

**FDibbins** · 09-18-2013, 03:18 AM

You could put a formula in the cell to test for whats in S4, but the 1st time you use the D/D, the formula will be over-written. You will need someone to write some VBA code for this, so I will move it to the VBA forum for you

**rini11** · 09-18-2013, 03:21 AM

The drop down will be used once. based on the selection a form is printed. On reopening the form the formula will be reset.

Create a Drop Down list if another cell meets certain criteria

LinkBack

Thread Tools

Rate This Thread

Display

Create a Drop Down list if another cell meets certain criteria

Re: Create a Drop Down list if another cell meets certain criteria

Re: Create a Drop Down list if another cell meets certain criteria

Re: Create a Drop Down list if another cell meets certain criteria

Re: Create a Drop Down list if another cell meets certain criteria

Re: Create a Drop Down list if another cell meets certain criteria

Thread Information

Users Browsing this Thread

Similar Threads

create a dynamic drop down list based on specific criteria

Excel 2007 : create a list where adjacent cell value meets criteria???

Find the last in a list that meets the certain criteria

List Rows where a cell meets criteria

Auto-Enter list into cell and record if cell meets various criteria automatically?

Bookmarks

Bookmarks

Posting Permissions