Worksheet_BeforeDoubleClick (allow if cell is numeric)

[terratushi]

Hi, I'm using the Worksheet_BeforeDoubleClick option. I have set the range as follows:

Please Login or Register  to view this content.

Is there a way to also restrict this to only cells that are numeric, if the cell contains anything else then cancel.

Thanks

[Mumps1]

The way your code is written, the "Cancel=True" line will be executed if you double click any cell outside of your target range. Is this what you want? Please explain in detail what you want to accomplish using a few examples and referring to specific cells and ranges. Attach a sample workbook if possible.

[terratushi]

Hi,

If the user clicks outside the range "D11:I19" then I want to cancel yes.
But also cancel if the user clicks within the range "D11:I19" and the cell value is not numeric

So looking at it the opposite way, the allowed range is "D11:I19" where a cell in that range contains a number. In English it would be range ""D11:I19" and is a number

I hope that makes sense?

Thanks

[kev_]

Try this as first line of sub

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[terratushi]

Hi guys, thanks for the replies! You've sorted it :D

[Mumps1]

Glad to help.