[Q] msoShapeRectangle: variable not defined

[Rolf Marvin Bøe Lindgren]

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 Marvin Bøe Lindgren]

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 Marvin Bøe Lindgren]

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!

 

[NickHK]

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

 

[NickHK]

Rolf,
VBA IDE, Tools>References. See the correct library.

NickHK