how can i insert a picturebox to a form in excel vba

[Min]

I want to insert a picturebox to form inisde Excel. But I
can't find this component. What can I do?

Somebody please help me. Thanks.

Min

[Vasant Nanavati]

Hi Min:

I'm not sure what you mean. I don't believe a VB PictureBox control can be
used in Excel. The Control Toolbox has an image control.
--
Regards,

Vasant.

**No direct emails please--keep discussion in newsgroup.**

"Min" <liu...@hotmail.com> wrote in message
news:164d01c1d9ce$30b56850$39ef2ecf@TKMSFTNGXA08...

[Min]

Thanks for your response. But I can't draw a line or
circle in image control box. I know I can use Shape object
of Excel, but it is limited for a password protected
sheet.
My intention is to show graphic of a simple structure as a
output when the size of the structure (as inputs) changed
in the textbox of Excel. I successfully finish it with
Shape object of Excel. But when I protect the sheet as
shared workbook, I realized that Shape object can't be
edited in a shared workbook. So I wonder maybe I can use
picturebox or other control toolbox instead.

Thanks again,
Min

>.
>

[Vasant Nanavati]

Sorry, I don't have a solution for you, Min. Perhaps someone else knows of a
workaround.
--
Regards,

Vasant.

**No direct emails please--keep discussion in newsgroup.**

"Min" <liu...@hotmail.com> wrote in message

news:14d301c1da54$a619eef0$9ae62ecf@tkmsftngxa02...