+ Reply to Thread
Results 1 to 7 of 7

Dragging/Moving Borderless/Titleless userform

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Dragging/Moving Borderless/Titleless userform

    Hi

    Any chance to dragg or move a userform ,borders and titlebar of which have been removed with API, with mouse?

    Best Regards
    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,192

    Re: Dragging/Moving Borderless/Titleless userform

    no, thats why it borderless, so you cant move it.
    Put the border back and you can move it.

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Dragging/Moving Borderless/Titleless userform

    It can be done but I agree that it would be far simpler to just not remove the title bar in the first place. Why did you do so?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Re: Dragging/Moving Borderless/Titleless userform

    Hi sir Don
    Thanks for the review.
    There is a situation I want to design a userform in VBA that should look like a form developed in another language. I can say just for design purposes to display VBA userform as to how the other form looks like.
    Attached Images Attached Images

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Dragging/Moving Borderless/Titleless userform

    Have a look at Andy Pope's code here- https://www.ozgrid.com/forum/forum/h...hout-title-bar

  6. #6
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Re: Dragging/Moving Borderless/Titleless userform

    Perfect like always...................
    Thanks=Thanks * 10000000000000000000000

    Best Regards
    Imran Bhatti

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Dragging/Moving Borderless/Titleless userform

    You're welcome.

+ 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. Manipulate points on charts by dragging/moving
    By krneki in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-16-2018, 11:30 AM
  2. [SOLVED] Dragging Userform Causes Ghosting?
    By delaing in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-10-2016, 12:23 PM
  3. Complete Borderless UserForm
    By rdrmdr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2016, 11:21 AM
  4. Replies: 9
    Last Post: 09-03-2012, 03:42 PM
  5. Borderless Form
    By Jacques Grobler in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-01-2011, 07:20 AM
  6. Dragging down and moving along colums, not rows
    By DerPumuckl in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2010, 01:36 PM
  7. Replies: 3
    Last Post: 06-14-2006, 04:51 PM

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