Hi,

I have a COM add-in which has methods to
a. invoke a form where a user may capture some data
b. return a single value.

I also have a VBA wrapper written to be able to hook this add-in in Excel.

I would like
a. to access the cells on the active worksheet from my add-in's
form(cell ranges are specified in the add-in form)
b. when the user types the function, that the function's parameters are
displayed(intellisense)

Your help will be appreciated

"Christoph Malherbe" <Christoph wrote in
message ...
Hi,

I have a COM add-in which has methods to
a. invoke a form where a user may capture some data
b. return a single value.

I also have a VBA wrapper written to be able to hook this add-in in Excel.

I would like
a. to access the cells on the active worksheet from my add-in's
form(cell ranges are specified in the add-in form)
b. when the user types the function, that the function's parameters
are
displayed(intellisense)

Your help will be appreciated


Is your COM add-in also an automation add-in?

/Fredrik