Paint controls in the vba toolbox?

[R. Langdon]

Hey,


I want to have some lines, boxes and circles on my excel vba userform.
In the excel vba toolbox there are no paint controls.
Where can I find these controls and how can I add them to my toolbox?

Thanks,

R. Langdon

 

[Chip Pearson]

Unfortunately, you can't draw shapes on userforms.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[TC]

Does a userform expose a window handle (hWnd)? (I don't know)

If so, perhaps he could use normal win32 API calls.

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[Chip Pearson]

You can use FindWindow to get the HWnd of a userform.

Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, ByVal lpWindowName As String) As
Long

Sub AAA()
Dim UserformHWnd As Long
UserformHWnd = FindWindow("ThunderDFrame", UserForm1.Caption)
If UserformHWnd <> 0 Then
' work with UserformHWnd
End If
End Sub

If you're working in Excel97, use "ThunderXFrame" instead of
"ThunderDFrame".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Andy Pope]

In case you didn't see this in the other Excel NG.

Hi,

Here is one approach you might be able to use.
http://www.andypope.info/vba/userformdraw.htm

Cheers
Andy