+ Reply to Thread
Results 1 to 3 of 3

Change color of ellipse on userform

  1. #1
    Registered User
    Join Date
    11-07-2013
    Location
    near Brussels, Belgium
    MS-Off Ver
    Excel 2010
    Posts
    6

    Change color of ellipse on userform

    I have an image om my userform and when I click on it, it draws a circle on the position I clicked. But it only draws the circle in white and I want to be able to draw it in red. Can anyone help me?

    Please Login or Register  to view this content.

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

    Re: Change color of ellipse on userform

    See this post for the API calls need to set brush/pen style and colour

    http://www.mrexcel.com/forum/excel-q...-userform.html
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-07-2013
    Location
    near Brussels, Belgium
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Change color of ellipse on userform

    Thanks for the help, Andy.
    However I couldn't get it to work like they say it. Eventually I found what worked for me by mixing the best of several sources together and adapting to my needs. I will share my piece of code with the community, who knows someday it may help someone else.

    PS my version is 64 bit so just remove the PtrSafe for 32 bit systems.
    Please Login or Register  to view this content.

+ 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. Graphing ellipse equation
    By Scott Smith in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-10-2020, 10:40 PM
  2. Can background color of frame change on userform by combobox selection on userfor
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2011, 05:47 PM
  3. Drawing an ellipse from cell data
    By Stoolie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2011, 04:03 PM
  4. Best fit ellipse
    By freshmaker in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-14-2008, 05:19 AM
  5. Userform-Change textbox color and font based on input in other tex
    By Neal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2005, 08:05 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