Excel UserForms on Surface Pro

Discussion in 'Microsoft Surface Pro' started by TedN, Mar 27, 2013.

  1. TedN

    TedN New Member

    Joined:
    Mar 9, 2013
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    0
    I raised this topic some weeks ago and it appears to have died. Since then I have talked extensively with Microsoft Support and have got nowhere. I'm hoping that more people now have tried to use UserForms on a touch screen.

    The problem is that scrolling of UserForms on a touch screen is limited to using a scrollbar. One cannot scroll a UserForm from the form itself. This defeats the object of touch screens. There's no problem with a spreadsheet. One can scroll, pinch, etc., from anywhere on the sheet.

    The last comments I got from Microsoft support was to go back to the Surface forum and raise the topic again. So here I am.

    So the question is: Can one scroll a UserForm on a touch screen from the form itself?

    If yes, what is required to implement this.
    If no, will this feature be added.

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

    Thank you.
     
  2. jnjroach

    jnjroach Administrator Staff Member

    Joined:
    Nov 9, 2012
    Messages:
    7,095
    Likes Received:
    1,724
    Trophy Points:
    113
    Location:
    Seattle, WA USA
    My Device:
    Surface Book
    Hi Ted,

    This is not the official Surface Support Channel, this is an enthusiast channel. I think you are looking for this forum:

    Surface - Microsoft Community

    Thanks,
     
    1 person likes this.
  3. Mcfly

    Mcfly New Member

    Joined:
    Aug 12, 2012
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Sugar Land, Texas
    I just tried it on one of my workbooks. At first it didn't seem to work (this was without the touch cover attached). I then tried it with the pen (dragging the scroll bar) and that got it going. Now it will scroll with my finger also. Then I tried it with touch cover attached using click and hold on the scroll bar. Again, works fine. I tried this on both Office 10 and 13. My finger is a little big on the surface so not sure if it was a fluke to get it going or just my finger technique??? Dumb question, you've checked all the settings in the userforms properties? Userforms are a little finicky on any machine...
     
  4. TedN

    TedN New Member

    Joined:
    Mar 9, 2013
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    0
    Hi McFly. Can you scroll the UserForm by touching the UserForm itself, not the scrollbar. That is what I'm trying to do. I want to be able to "flick" the form up and down with my finger by swiping anywhere on the form - just like it's possible with a spreadsheet.
     
  5. Garyjk

    Garyjk Member

    Joined:
    Feb 24, 2013
    Messages:
    120
    Likes Received:
    16
    Trophy Points:
    18
    i have a contact that's a program manager on the excel team. i'll ask him when/if this will ever happen?
     
  6. Garyjk

    Garyjk Member

    Joined:
    Feb 24, 2013
    Messages:
    120
    Likes Received:
    16
    Trophy Points:
    18
    ok, heard back from him and right now it's not on the radar, but it is important to make excel as touch friendly as possible. that's all i have.
     
  7. seaham358

    seaham358 New Member

    Joined:
    Mar 6, 2013
    Messages:
    16
    Likes Received:
    2
    Trophy Points:
    3
    I have Office 2013 installed and I can scroll using the touch screen anywhere on the page and it scrolls up and down left to right.
    When I first opened the spread sheet sent to me through an email it would only open 3/4 not the whole screen. After messing with it open,close open,close and so on it opened in full page. No issues at all now.
     
  8. Mcfly

    Mcfly New Member

    Joined:
    Aug 12, 2012
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Sugar Land, Texas
    No, it only scrolls by holding the scroll bar itself. And like you say, the spreadsheet scrolls just fine.

    BTW, this functions the same on my desktop pc as well (you can only scroll the userform with the scroll bar) using win7 / office07 on the desktop pc.
    Same with the scroll wheel on the mouse. It will scroll the sheet but not the userform.
     
    Last edited: Mar 28, 2013
  9. TedN

    TedN New Member

    Joined:
    Mar 9, 2013
    Messages:
    17
    Likes Received:
    1
    Trophy Points:
    0
    I was finally able to talk to a Microsoft support person who was familiar with both Excel userforms and touch screens. He said that since userforms are an add-on to the main Excel package scrolling other than by using the scrollbar has not been provided. He had no idea if it would be provided in a future update.
     

Share This Page

Search tags for this page
excel on surface pro
,

excel on surface pro 2

,
excel userform touch
,
how do you open a spread sheet in excel on a surface pro 2
,
microsoft pro surface 3 excel
,
microsoft surface pro excel
,
surface 2 excel userform compatible
,

surface pro excel

,
using excel on surface
,
using excel on surface pro