Blank Drop Down List with If Statement

[cwalenciak]

I have code that adds a drop down list to certain cells. I want the user to be able to leave a drop down list blank. What I am having trouble with is writing an if statement that skips a blank cell with a drop down list.

So if Cell(1, 2) has a drop down list and the user leaves it blank, what is the code I need to write to identify its as blank.

I have tried IsNull(Cell(1,2) = False, but that is not working.


Thanks!

 

[Oeldere]

Maybe like this.

=if(b1="","",your code)

 

[cwalenciak]

Maybe like this.

=if(b1="","",your code)

I made a mistake (i was using "or" instead of "and"). Your suggestion and isNull worked.

Thanks!