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 " schrieb
im Newsbeitrag ...
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 " a écrit dans
le message de ...
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

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/