+ Reply to Thread
Results 1 to 9 of 9

Thread: Borderless Form

  1. #1
    Valued Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    212

    Borderless Form

    Afternoon all,

    I recently saw a form running without a border, is it possible to have an excel (or vba for that matter) display without a border?

    Thanks
    Jacques


  2. #2
    Registered User
    Join Date
    11-03-2010
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Borderless Form

    HI Jacques,
    As of my Knowledge its not possible. But you can design that in VB.net

  3. #3
    Forum Guru, retired Admin royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    25,640

    Re: Borderless Form

    What do you mean by borderless? Maybe no Header, if so this is possible. However you can't drag a borderless form out of the way, I have code written by Andy Pope for this but it's at home
    Hope that helps.

    RoyUK
    --------
    If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need

    For Excel Tips & Solutions, free examples and tutorials why not check out my downloads

    New members please read & follow the Forum Rules

    Remember to mark your questions Solved and rate the answer(s)

  4. #4
    Valued Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Borderless Form

    Hi Roy,

    My apologies, yes it is headerless (the blue block at the top of a form), I understand that you still need a border.
    Jacques


  5. #5
    Forum Guru snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,151

    Re: Borderless Form

    cfr the attachment
    Attached Files Attached Files



  6. #6
    Valued Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Borderless Form

    Hi Snb,

    It is what I am looking for but the code does not make sense to me, can you please just explain a little bit?
    Jacques


  7. #7
    Forum Guru snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,151

    Re: Borderless Form

    How much time have you got ?

    I fear there's too litle space here to tell you all the ins & outs of the code. Basically the code uses Window's facilities from Window's DLL files.
    Perhaps you should start on the site of the villains that designed this in the first place to get a glimpse of how to use VBA in handling Windows.
    Last edited by snb; 07-01-2011 at 07:35 AM.



  8. #8
    Valued Forum Contributor
    Join Date
    01-15-2010
    Location
    Jhb, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Borderless Form

    Hi snb,

    The site you propose seems to be unavailable.
    Jacques


  9. #9
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: Borderless Form

    Try this link.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.2.0