Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Q] msoShapeRectangle: variable not defined
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable sum from defined input | Excel Worksheet Functions | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
[Q] msoShapeRectangle: variable not defined | Excel Programming | |||
[Q] msoShapeRectangle: variable not defined | Excel Programming | |||
Variable Not Defined? objPivotCache | Excel Programming |