I'm fairly new to drawing objects in Excel from VBA, and have stumbled
on a peculiar issue. the variable msoShapeRectangle, which apprarently
is suppoed to be predefined, is not declared.

I've recorded the following from Excel:

ActiveSheet.Shapes.AddShape(msoShapeRectangle, 303#, 48#, 255#,250.5)._
Select

compliation is aborted with the error message "msoShapeRectangle :
Variable not defined". if I don't set "Option Explicit" it compiles,
but the value of msoShapeRectangle is Empty. it is used in another
worksheet programmed by somebody else and it works perfectly there.

the variable msoTrue is also undefined.

this is Excel 10 (Excel 2002).

any clues?

thank you,


--
Rolf Lindgren http://www.roffe.com/

"NickHK" writes:

Rolf,
It's from the Microsoft Office library, defined as a MsoAutoShapeType, with
value=1. Maybe you do not have a reference set to this library.

OK, but how do I establish such a referance? as stated, this works in
a workbook that's been made by somebody else - it's in the workbook
that I'm working on that it doesn't work.

--
Rolf Lindgren http://www.roffe.com/

"Rolf Marvin Bøe Lindgren" writes:

"NickHK" writes:

Rolf,
It's from the Microsoft Office library, defined as a MsoAutoShapeType, with
value=1. Maybe you do not have a reference set to this library.

OK, but how do I establish such a referance? as stated, this works in
a workbook that's been made by somebody else - it's in the workbook
that I'm working on that it doesn't work.

found it. Tools - References - ... lots of stuff.

thanks!

--
Rolf Lindgren http://www.roffe.com/

Rolf,
It's from the Microsoft Office library, defined as a MsoAutoShapeType, with
value=1. Maybe you do not have a reference set to this library.

Nick

"Rolf Marvin Bøe Lindgren" wrote in message
...
I'm fairly new to drawing objects in Excel from VBA, and have stumbled
on a peculiar issue. the variable msoShapeRectangle, which apprarently
is suppoed to be predefined, is not declared.

I've recorded the following from Excel:

ActiveSheet.Shapes.AddShape(msoShapeRectangle, 303#, 48#, 255#,250.5)._
Select

compliation is aborted with the error message "msoShapeRectangle :
Variable not defined". if I don't set "Option Explicit" it compiles,
but the value of msoShapeRectangle is Empty. it is used in another
worksheet programmed by somebody else and it works perfectly there.

the variable msoTrue is also undefined.

this is Excel 10 (Excel 2002).

any clues?

thank you,


--
Rolf Lindgren
http://www.roffe.com/

Rolf,
VBA IDE, ToolsReferences. See the correct library.

NickHK

"Rolf Marvin Bøe Lindgren" wrote in message
...
"NickHK" writes:

Rolf,
It's from the Microsoft Office library, defined as a MsoAutoShapeType,
with
value=1. Maybe you do not have a reference set to this library.

OK, but how do I establish such a referance? as stated, this works in
a workbook that's been made by somebody else - it's in the workbook
that I'm working on that it doesn't work.

--
Rolf Lindgren
http://www.roffe.com/