+ Reply to Thread
Results 1 to 5 of 5

Create additional border for userform

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Create additional border for userform

    Hi Guys,

    i want to create form shape like here:

    Screenshot_20.png

    I removed topbar so i have my own "topbar" drew the small rectangle and added bigger width of border.

    Can anybody help how to do this?
    Best,
    Jacek

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,158

    Re: Create additional border for userform

    Seems you have already done what is required...What do you need from us...
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Create additional border for userform

    i need to get shape like in the screen above sintek, thanks for writing.

    So how you would do userform like in screen above? What objects to use?

    Best,
    Jacek

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,429

    Re: Create additional border for userform

    I think what is confusing us is that you say have done it, and ask for help on doing it.

    Let's assume you have the API code to deal with the caption bar.
    The border could be done using a background picture on the userform. The picture would be that of a rectangle with a thick border in the appropriate colours.
    Or you could use 2 label controls sized to userform inside dimensions and then a slightly smaller on which would generate a border.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Create additional border for userform

    Thank you Andy for tips.

    I created this topic to not do any more confusion but i made , sorry for that.

    Great tips, i will try with the rectangules.

    Best,
    Jacek

+ 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. Remove Userform Border 64bit
    By ghostexcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2016, 07:49 AM
  2. Continue Border for additional columns
    By rkaeatchley in forum Excel General
    Replies: 3
    Last Post: 04-05-2016, 03:39 PM
  3. Adding additional inputs on userform vba
    By ashburnadam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2015, 09:18 PM
  4. [SOLVED] Userform Border Issue Windows 7
    By ttyler333 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2014, 06:32 AM
  5. Userform additional controls
    By tradinup2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2013, 10:48 AM
  6. [SOLVED] Mysterious additional border to left of rows border?
    By Oppressed1 in forum Excel General
    Replies: 2
    Last Post: 10-10-2012, 03:22 PM
  7. [SOLVED] how do I import additional border types into excel?
    By Jo in forum Excel General
    Replies: 1
    Last Post: 03-15-2006, 09:10 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