PictureBox in Excel VBA

[[email protected]]

I have an application in vb6 which uses picturebox control. I would
like to leverage the same functionality in excel, but could not find
the picturebox control or any equivalent one vba. Is there any work
around?
Thanks in advance, Binesh

[Leith Ross]

Hello Binesh,

VBA doesn't have a PictureBox control like VB. If the Picture is a BMP file you could copy it to a Shape Object. If your pictire maight be a IMG, JPG, BMP, ICO, or CUR, then use an Image Control from VBA's Control ToolBox.

Sincerely,
Leith Ross

[keepITcool]

Try the IMAGE control from msforms library.
less functionality, and i dont know what you exactly want to do ,
but it'll probably be sufficient.


Picturebox is an ActiveX control,so you could use the picturebox in VBA
too. however:
your users must have a licensed version of the control
on their machine. VBA is uncompiled so a "designtime" license is
required.
Since most users will not have vb or office developer license
this will not be the most practical solution.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


[email protected] wrote :

> I have an application in vb6 which uses picturebox control. I would
> like to leverage the same functionality in excel, but could not find
> the picturebox control or any equivalent one vba. Is there any work
> around?
> Thanks in advance, Binesh

[[email protected]]

Thanks Ross and KeepITCool for the information.
In fact, what I really require is to draw a 2d cross section based on
geometric inputs on a canvas. Right Now, I am using shapes in
Worksheet(which serves the purpose, Not efficient,though) for this.
Just wondering if there is better alternative?

Binesh