Assignibg a value to a property from a cell

[Avi]

Hello,

I use an external object called AngleGauge with a property AngleStyle which
accept values like LEFTBOTTOM_ANG

A typical line looks like AngleGauge1.AngleStyle= LEFTBOTTOM_ANG, that works
fine

The problem is that i want the value to come from a cell in Excel
(AngleGauge1.AngleStyle= MyValue), but then i get a mysmatch error

Could you help?

Avi
www.avibenita.com

 

[Mike Mertes]

Avi,

Your AngleStyles must be constants or an enumeration declared somewhere in
the AngleGauge's library. Try executing a line of code like this:

msgbox LEFTBOTTOM_ANG

You should get a message box returning the numerical value that your
constant holds. Use these values in your cells to avoid type mismatch. Or,
you could write a small procedure to convert the AngleStyles like,
"LEFTBOTTOM_ANG," found in cells to their respective numerical values and
pass those to the AngleGauge object, instead.

HTH.
-Mike

 

[Avi]

Thanks a lot! Works perfectly

Avi

Avi Benita 054-4660641 wwwAvi Benita 054-4660641 www.avibenita.com