Picture control in Excel/VBA ?
 

Hello,

I would like to insert a Picture control in a Userform (to draw inside) but
it does not appear in the control toolbox (in the extra control list
either...).
I am not sure it is available in VBA. Any idea ?

More generally, is there any way to use VB instructions such as 'Pset, Line,
Circle...' in a Userform ? (or possibly other ones that give the same
results...)
Thanks for any help

PS : I have an Excel 2002

--
Emeric

Picture control in Excel/VBA ?
 

Hey Emeric,

There's an OCX available at:

http://www.vbcodesource.com/control.html

that gets good things said about it.

Else you could look into shelling out into Paintbrush - unless you want
to makes shapes programmatically (which from your email I guess you to)
in which case could you use Excel's drawing functionality? (On a
worksheet that is - not a userform AFAIK.)

HTH,
Gareth


Emeric wrote:
Hello,

I would like to insert a Picture control in a Userform (to draw inside) but
it does not appear in the control toolbox (in the extra control list
either...).
I am not sure it is available in VBA. Any idea ?

More generally, is there any way to use VB instructions such as 'Pset, Line,
Circle...' in a Userform ? (or possibly other ones that give the same
results...)
Thanks for any help

PS : I have an Excel 2002

Picture control in Excel/VBA ?
 

There's an OCX available at:

http://www.vbcodesource.com/control.html

that gets good things said about it.

in fact I was looking for a standard control or instruction (not "custom").
But thanks Gareth, if I ever don't find an other solution I will use this
OCX ;)

Else you could look into shelling out into Paintbrush - unless you want
to makes shapes programmatically

yes I want to draw programmatically !

--
Emeric

Picture control in Excel/VBA ?
 

Have you seen this?

http://www.andypope.info/vba/userformdraw.htm

I haven't opened it but it looks like it might do what you need.

Emeric wrote:
There's an OCX available at:

http://www.vbcodesource.com/control.html

that gets good things said about it.


in fact I was looking for a standard control or instruction (not "custom").
But thanks Gareth, if I ever don't find an other solution I will use this
OCX ;)


Else you could look into shelling out into Paintbrush - unless you want
to makes shapes programmatically


yes I want to draw programmatically !