+ Reply to Thread
Results 1 to 3 of 3

How to add rounded corners to a userform

  1. #1
    Registered User
    Join Date
    02-18-2014
    Location
    england
    MS-Off Ver
    2019
    Posts
    13

    How to add rounded corners to a userform

    Trying to fancy up my excel VBA userforms a little. Does anyone know how to create rounded corners on the forms?

    Is there anything else you can do to make them look a little more attractive? Drop shadows etc?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: How to add rounded corners to a userform

    You will need to use Windows API. Personally, I'd not bother with it

    But check Leith Ross's code in thread linked below.
    https://www.excelforum.com/excel-pro...dern-look.html

    Note: When tested on my environment (Win10, Excel 64bit, I had to make few changes). Specifically, where API functions were declared to return LongPtr had to be changed to Long. See attached.
    Attached Files Attached Files
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    02-18-2014
    Location
    england
    MS-Off Ver
    2019
    Posts
    13

    Re: How to add rounded corners to a userform

    Thank you for your honest opinion, and apologies for my delayed reply. I thought I had replied previously.

    I had come across Leith Ross's code which rendered with the approximate beauty of Chewbacca's Backside in a thong! I also have win10, Excel 64bit, so maybe this is the issue, or maybe, just like Chewbacca's ar*e, it's never going to be pretty.

    I'm a whizz with Excel, and my business runs entirely on its abilities to automate the mundane stuff. I think I'm going to have to brush up a little on the VBA before having a fully fledged system that looks as pretty as it runs. I refuse to purchase that which I can learn to design myself!

+ 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. [SOLVED] Pivot Table Rounded Corners?
    By formulacurious in forum Excel General
    Replies: 3
    Last Post: 07-11-2019, 02:40 PM
  2. Can't Drag Corners
    By andrealight1 in forum Excel General
    Replies: 1
    Last Post: 11-07-2014, 06:59 AM
  3. syntax for comparing a rounded number to a rounded list
    By stockgoblin42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2013, 10:12 AM
  4. [SOLVED] Green corners
    By dcwm in forum Excel General
    Replies: 2
    Last Post: 12-29-2012, 10:37 AM
  5. Ticks in the cell corners
    By oldron34 in forum Excel General
    Replies: 1
    Last Post: 07-11-2007, 03:20 PM
  6. [SOLVED] Border Colors and Corners
    By mjones in forum Excel General
    Replies: 3
    Last Post: 04-06-2006, 11:00 AM
  7. rounded corners in charts not in newer Excel version
    By jeffreyfarrell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-31-2005, 10:20 PM

Tags for this Thread

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