Excel UserForms and Surface Pro

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

  1. TedN

    TedN New Member

    Mar 9, 2013
    Likes Received:
    Trophy Points:
    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.


Share This Page

Search tags for this page
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 vba excel

surface pro and excel


surface pro excel vba


surface pro excel youtube

surface pro for advanced excel
vba excel 2013 surface pro 3