Hi there

whenever i type an enumeration member of the CommandBar into a cell, in a
speadsheet, I get #NAME? error. For example, if I type "=msoBarTop", I'd
expect the value of 1, instead I get an error.

Am I missing something, like an add-in, in my Excel application; I have the
Analysis ToolPaks Add-ins referenced.

Thanks
ade

You can't look at VBA value from within a sheet cell like that.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"adewole" wrote in message
...
Hi there

whenever i type an enumeration member of the CommandBar into a cell, in a
speadsheet, I get #NAME? error. For example, if I type "=msoBarTop", I'd
expect the value of 1, instead I get an error.

Am I missing something, like an add-in, in my Excel application; I have
the
Analysis ToolPaks Add-ins referenced.

Thanks
ade