Shapes in a userform 1

[WaterSprite]

I can make shapes, Triangles, circles, oval's etc on a spreadsheet.
I have tried creating Geometric shapes on just the VBA userform, did not work. I even tried copying VB6 code to VBA and that did not work either.
What I did not try was trying to create Geometric shapes inside a TextBox, Frame, Image, etc.
My actual question is, can I create Geometric shapes on a VBA UserForm?
I am not even asking for examples, just a yes or no so I know whether to keep trying or not. But, any examples gratefully accepted and acknowledged.

Thanks for the help.

WaterSprite

 

[KenPuls]

So far as I'm aware, you can't. You could add a picture, though, so if you have a picture of a shape that has a transparent background, that may be a workaround.

HTH,

Ken Puls, CMA

http://www.excelguru.ca

 

[taupirho]

I wasn't sure if you meant adding shapes to a userform programmatically - for sure you can do this. If you're talking about manually drawing shapes on a userform you are out of luck, however a frame of height 1 or 2 and long length with a black backgroung colour make for a convincing horizontal line. Similarly one with a width 1 or 2 and large height make a good vertical line. You now have the facility to "draw" a box on your userform. Thats about it though.

 

[WaterSprite]

yes, I need to do shapes programatically. What I want to do is images of tanks, pumps, liquid levels, etc.