Macro on double click, is it correct in this way in VBA?

**mehidy1437** · 11-13-2019, 02:19 PM

Hi Guys,

Below code is working fine, I just want to make sure that this is the right way or not?
If active cell column is equal to 8 to 18, then on double click on the cell, it will call the Work vba/macro.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**CK76** · 11-13-2019, 02:26 PM

I would do it without looping. And Cancel = True should be nested inside IF statement.

Ex:

Please Login or Register  to view this content.

**Fluff13** · 11-13-2019, 02:28 PM

No need for the loop, you can do it like

Please Login or Register  to view this content.

Macro on double click, is it correct in this way in VBA?

LinkBack

Thread Tools

Rate This Thread

Display

Macro on double click, is it correct in this way in VBA?

Re: Macro on double click, is it correct in this way in VBA?

Re: Macro on double click, is it correct in this way in VBA?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Double Click one sheet and replicate Double Click "mark" on other sheets

Pivot Table Double Click Show Correct records

[SOLVED] Add 1 to target on double click, add 0.5 on shift + double click

Changing cell properties with double click, then revert with another double click

Double click to run a macro

Run macro on double click only

vlookup: I have to double click each cell to get correct results?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions