Using Add-in worksheet with Function VBA

[somkiat]

How to use worksheet inside add-in file with its add-in function?

I have a very big calculation table created with Excel functions. It is very difficult to revise all formulas to VBA procedure.

Can we use Function VBA to pass inputs to worksheet inside add-in file,

then use formula and functions within add-in worksheet to calculate,

then return answer back to VBA function?

Thanks,

Somkiat
www.ExcelExpertTraining.com
xls@i.am
Thailand

 

[somkiat]

Thanks for the limitations that should be weighted with time-saving from writing VBA codes.

This question came from one of my forum member who have huge Excel worksheet that seems impossible to convert to VBA codes.

This is a creative way that is just a first step to break Excel's limits. Need more improvement from all Excel lovers.

Instead of using Range Names or Active Workbook, we may create first-step VBA to search for any opened workbooks. Let reserve some specific cells for input that will send data into Add-in worksheet.

We may use Dynamic Range Name that relocates among different sheets. Data Table and Index may be applied later to send more data using the same formula.

This is simply the first step with many limitations. Please suggest ways for the next.

Thanks,

Somkiat
www.ExcelExpertTraining.com