Conditional Worksheet Events

**max57** · 01-31-2010, 04:48 PM

Hello,

I would like to have a nested if or select case statement to handle a worksheet event.
The conditions it will check are:
1. Make sure target is w/in range, otherwise EXIT
2. Make sure that target offset value is not empty, otherwise display message
3. All is good, open form

I’ve tried various formulations and positionings of the statements ,but not all conditions are met with equal success.
What happens is I get the the first two conditions, but the third doesn’t work.

Please Login or Register  to view this content.

I’ve attached a workbook for clarification

Thanks
Mark

**Leith Ross** · 01-31-2010, 04:55 PM

Hello Mark,

Change this statement...

Please Login or Register  to view this content.

To this....

Please Login or Register  to view this content.

**max57** · 01-31-2010, 05:27 PM

Hi Leith,
I fixed the code as suggested, but alas, no go.
I tried various permutations of the If statement but I think I'm missing something regarding the syntax.

Here is the code as it stands now:

Please Login or Register  to view this content.

I've attached the latest version of the worksheet to illustrate what's going on.

Thanks!

Mark

**Leith Ross** · 01-31-2010, 07:15 PM

Hello Max57,

Here is the working code for the DoubleClick macro...

Please Login or Register  to view this content.

**max57** · 01-31-2010, 07:40 PM

Hello Leith,

Exactly what I needed.

Please Login or Register  to view this content.

I had tried "Is Empty "to no avail. I was thinking about looking for another way to check the cell, but this bit of code wasn't even on my radar.

One question: What purpose does Resize(1,4) serve in this example?

Much obliged!

Mark

**Leith Ross** · 01-31-2010, 08:22 PM

Hello Mark,

The Resize property allows you to change the number of rows and columns for a cell or range. For example, if the cell is "B10" then the range is expanded to 1 row by 4 columns so the working range is now "B10:E10".