Call user defined function in an add-in
 

In addition to the previous post, I would like to be able to call a function
that resides in an add-in from a cell in a spreadsheet.

When I type: =FormatChart(yada, yada, yada....)
into a cell, the function seems to lock up. One of the things about this
function is that is it selects a specific worksheet, and then actually
selects cells in that worksheet. Might this be causing some of my problems?
Should I modify the code so that it only points to the sheet and cells rather
than actually selecting them?

Dale
--
Email address is not valid.
Please reply to newsgroup only.

Call user defined function in an add-in
 

UDF's used in a worksheet cell can't do things like selecting sheets. They
can't return a value to another cell, either. (Just a warning <bg.)



Dale Fye wrote:

In addition to the previous post, I would like to be able to call a function
that resides in an add-in from a cell in a spreadsheet.

When I type: =FormatChart(yada, yada, yada....)
into a cell, the function seems to lock up. One of the things about this
function is that is it selects a specific worksheet, and then actually
selects cells in that worksheet. Might this be causing some of my problems?
Should I modify the code so that it only points to the sheet and cells rather
than actually selecting them?

Dale
--
Email address is not valid.
Please reply to newsgroup only.

--

Dave Peterson

Call user defined function in an add-in
 

rather than actually selecting them.

Getting out of the Select habit is a very good move. It is almost NEVER
necessary to select anything in VBA. ActiveWindow.FreezePanes = True is the
only time that I can think of that you need to Select anything.

Not using Select will make your code faster and much more maintainable.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Dale Fye" wrote in message
...
Thanks, Dave. I guess I'll have to rewrite the function so that it
references the worksheets and cells, rather than actually selecting them.

Dale
--
Email address is not valid.
Please reply to newsgroup only.


"Dave Peterson" wrote:

UDF's used in a worksheet cell can't do things like selecting sheets.
They
can't return a value to another cell, either. (Just a warning <bg.)



Dale Fye wrote:

In addition to the previous post, I would like to be able to call a
function
that resides in an add-in from a cell in a spreadsheet.

When I type: =FormatChart(yada, yada, yada....)
into a cell, the function seems to lock up. One of the things about
this
function is that is it selects a specific worksheet, and then actually
selects cells in that worksheet. Might this be causing some of my
problems?
Should I modify the code so that it only points to the sheet and cells
rather
than actually selecting them?

Dale
--
Email address is not valid.
Please reply to newsgroup only.

--

Dave Peterson