If you're not setting a reference to Excel in your VB project, VB will
not know the value of the constant xlLabelPositionAbove, which is 0.

My object browser does not find "xlDataLabelAbove", and recording a
macro uses "xlLabelPositionAbove".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

chazman wrote:

I am trying to use the DataLabel.Position contruct to change the position of
a data label based on which series of chart data that it represents. Using a
statement like DataLabel.Position = xlDataLabelAbove seems to work fine in a
macro. When I try to use the same code within a vB function I get an error
on the statement line.
Any suggestions would be appreciated.