Excel UserForms and Surface Pro

Discussion in 'Microsoft Surface Pro' started by TedN, Apr 12, 2013.

  1. TedN

    TedN New Member

    Joined:
    Mar 9, 2013
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    0
    By using an API I thought I had a solution to changing UserForm size automatically based on tablet orientation. Unfortunately the solution only works when the orientation (landscape - portrait) is changed manually, i.e. selecting one or the other through the control panel. It doesn't work when the orientation is changed by physically rotating the tablet.

    So is there a way of accessing actions on a tablet so that they can trigger events in my VBA coding. APIs that work on my PC don't get triggered from actions on the tablet.

    The specific tablet actions I would like to access are:

    1. Tablet Rotation
    I need to trigger an event to resize a UserForm when the tablet is rotated.

    2. Scroll
    UserForms do not scroll when a finger is moved up or down the main form. The finger has to be located on the scrollbar. I would like to detect when a finger is moved on the touch screen. I could then use this to trigger an event to scroll the form.

    3. Virtual Keyboard
    When a textbox is selected in a UserForm the virtual keyboard doesn't automatically appear, it has to be manually selected. Is there a way of detecting when an item on a tablet is selected for text entry.

    I am using a Microsoft Surface Pro, Windows 8 and Office 2013.


    Thanks,
     

Share This Page

Search tags for this page
adding photo to excel macro with surface tablet
,
excel launch keyboard on surface win8 in vba
,
excel userform scrolling tablet
,
excel vba surface pro 3
,

identify rotation windows 8 vba excel 2013

,
surface pro 3 excel vba
,
surface pro 3 vba excel
,

surface pro and excel

,

surface pro excel vba

,

surface pro excel youtube