Arrow navigation needs to skip over cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MaverickPS@gmail.com - 14 Dec 2007 02:54 GMT

I created some VBA code that pops up a little date picker calendar
whenever specific cells become activated. Problem is that when people
are moving around in the spreadsheet with the arrow keys and they hit
one of these cells the calendar pops up and stops them.

I want to make it so that the arrow keys skip over these cells and the
pop-up only happens when the cell is clicked with the mouse. Any ideas?

Reply to this Message

Gord Dibben - 14 Dec 2007 03:19 GMT

I assume some type of event code is currently in place.

I would suggest you could change your code to Worksheet_BeforeDoubleClick event.

Then Double-click on the specific cells will bring up the calendar.

Gord Dibben MS Excel MVP

>I created some VBA code that pops up a little date picker calendar
>whenever specific cells become activated. Problem is that when people
[quoted text clipped - 3 lines]
>I want to make it so that the arrow keys skip over these cells and the
>pop-up only happens when the cell is clicked with the mouse. Any ideas?

Reply to this Message