Is there any way to draw a circle on a userform and give it a color

- Mangesh


---
Message posted from http://www.ExcelForum.com/

Hi
aFAIK not possible

--
Regards
Frank Kabel
Frankfurt, Germany

"mangesh_yadav >" <<(E-Mail Removed)> schrieb
im Newsbeitrag news:(E-Mail Removed)...
> Is there any way to draw a circle on a userform and give it a color
>
> - Mangesh
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

You could create graphic files of coloured circles, and insert them into
the UserForm as images. Show or hide them as required.

mangesh_yadav < wrote:
> Is there any way to draw a circle on a userform and give it a color


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks.

- Manges

--
Message posted from http://www.ExcelForum.com

Yes, but that would require me to carry the image files everywhere alon
with the excel application.

Manges

--
Message posted from http://www.ExcelForum.com

Hi mangesh_yadav,
If you can be satisfied with the default color:
Private Declare Function GetActiveWindow Lib "user32" () As Long
Private Declare Function GetWindowDC Lib "user32" _
(ByVal hWnd As Long) As Long
Private Declare Function Ellipse Lib "gdi32" (ByVal hDC As Long _
, ByVal X1 As Long, ByVal Y1 As Long, ByVal X2 As Long _
, ByVal Y2 As Long) As Long

Private Sub UserForm_Activate()
DoEvents
Ellipse GetWindowDC(GetActiveWindow), 10, 40, 90, 120
End Sub

Regards,
MP

"mangesh_yadav >" <<(E-Mail Removed)> a écrit dans
le message de news:(E-Mail Removed)...
> Is there any way to draw a circle on a userform and give it a color
>
> - Mangesh
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

I read Debra's suggestion as designing the userform with all the shapes/images
included. Then use code to hide/show the ones you want.



"mangesh_yadav <" wrote:
>
> Yes, but that would require me to carry the image files everywhere along
> with the excel application.
>
> Mangesh
>
> ---
> Message posted from http://www.ExcelForum.com/

--

Dave Peterson
(E-Mail Removed)

> Yes, but that would require me to carry the image files everywhere along
> with the excel application.
>
> Mangesh

Mangesh, it wouldn't require this at all if you do this at design time.

Hi Michel,

Thanks for the response. I will try it out and come back in case of an
difficulties. I hope it doesn't require any addins or new settings.

- Manges

--
Message posted from http://www.ExcelForum.com

Thanks to everyone

Mangesh


---
Message posted from http://www.ExcelForum.com/