10

Is there code for capturing screen gestures or screen swipes in Excel 2016 running on tablets? I'm looking for code that I can control with a screen swipe or screen gestures. For example, screen swipe left select a different tab or run code, etc. ?? Trying to simulate tablet behavior in excel 2016 on tablets.

Mesut Akcan
  • 900
  • 7
  • 17
FTSC
  • 190
  • 1
  • 7
  • Could this be accomplished by tracking the cursor? (I don't actually know if there are cursors on tablets...) – seadoggie01 Apr 14 '16 at 16:30
  • 3
    I believe "swiping" is simply interpreted as scrolling in excel. You're looking at implementing gestures in excel? Might have to utilize a different library and implement it through a .NET excel addin, unless it has COM support. People have implemented Intel RealSense into excel this way, so I don't see why you wouldn't be able to with gestures. (Possibly using the windows API) – Cody Ｇ May 09 '16 at 14:18
  • Have you actually seen this working in excel? I'd be interested in seeing how it was implemented. – FTSC May 15 '16 at 20:58
  • I don't think user input capturing has ever been part of Excel's object model. If it's a tablet or hybrid running Windows, what you're looking for is probably the [MSDN library](https://msdn.microsoft.com/library) Windows APIs. – AjimOthy Aug 04 '17 at 02:35
  • This depends on what tablet you're using. And I'm not sure VBA is the language you'd be using for it. – jDave1984 Sep 22 '17 at 17:53

1 Answers1

0

I use the TouchMe Gesture Studio to create this effect. It has a number of preset gestures, but for a lot of my work in Excel, I just linked the gestures to keyboard shortcuts. In your case you would want something like a 2-finger-swipe-left to correspond to ctrl+pageDown and swiping right to correspond to ctrl+pageUp

In my observation, the preset options tend to work better than the keyboard shortcuts, but I am satisfied with using gestures to cut/paste/undo/redo in excel.

Just as a note, the gesture studio also requires the the TouchMe Gesture Engine. You get a 30-day free trial period before you either have to purchase the engine, or limit yourself to three gestures.

Developer Guy
  • 2,012
  • 6
  • 17
  • 30
Christopher
  • 341
  • 1
  • 6