+ Reply to Thread
Results 1 to 5 of 5

Userform to slide in when triggered.

  1. #1
    Forum Contributor
    Join Date
    10-25-2016
    Location
    Derby, England
    MS-Off Ver
    MS 2013
    Posts
    228

    Userform to slide in when triggered.

    Hi,

    I already have a userform that slides in when triggered but what I would like to know is, is it possible to alter the way the userform slides?

    At the moment my userform slides from the left to right. I was wondering if it was possible to slide from top to bottom?

    Just select the entry form tab from the attached file to see the example.

    Any help would be appreciated.

    Thanks

    Dan
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Userform to slide in when triggered.


    Hi,

    just play with the UserForm Top property rather than the Left one …

  3. #3
    Forum Contributor
    Join Date
    10-25-2016
    Location
    Derby, England
    MS-Off Ver
    MS 2013
    Posts
    228

    Re: Userform to slide in when triggered.

    Hi,

    Sorry I don't think I have explained it properly. When I say I want it to slide from top to bottom I meant the animation when the userform opens, at the moment it slides from left to right.

    If I have misunderstood your reply then I'm sorry again. This is all above my head i'm afraid. Could you explain it by pointing out which part of the code I would need to alter?

    Thanks Dan

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question Re: Userform to slide in when triggered.


    Which property do you use in your code ?

  5. #5
    Forum Contributor
    Join Date
    10-25-2016
    Location
    Derby, England
    MS-Off Ver
    MS 2013
    Posts
    228

    Re: Userform to slide in when triggered.

    Hi,

    I've managed to do it.

    This is what was in my code originally:
    Please Login or Register  to view this content.
    So after searching online this morning and finding this code:
    Please Login or Register  to view this content.
    So I changed all the relevant parts of the code from one to the other and now it is working the way I wanted.

    Thank you for taking the time to reply to my thread.

    Dan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 07-18-2019, 07:43 AM
  2. Replies: 0
    Last Post: 05-02-2017, 07:10 AM
  3. Inserting Slides from Another Presentation Removes Slide Numbering & Footer on Slide
    By PSSMargaret in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 05-15-2016, 09:21 AM
  4. VBA reference slide from Userform
    By brewsi in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 04-16-2015, 07:00 AM
  5. How to know which shape as triggered the userform
    By kebec_ska in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 11:26 AM
  6. Replies: 1
    Last Post: 04-02-2012, 03:57 PM
  7. Modifying Chart Slide Show in a Userform
    By siamadu in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2009, 05:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1