ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XLA and strong typing (https://www.excelbanter.com/excel-programming/281083-xla-strong-typing.html)

[email protected]

XLA and strong typing
 
Hi
I have a workbook with several sheets. The flow thru
the "application" is staitc. The VBA changes a lot and
therefor I want to have most of the code in an XLA so I do
not have to change all the users Workbooks. The problem is
that I am found of stong typing and I have not managed to
incoperate strong typing and XLA. For example:
In my Workbook, which have a reference to the XLA, I have
a sheet called Sheet1 with several comboboxes. I want to
pass Sheet1 to a XLA function which popultes the boxes,
but I can not do that because the XLA do not know the type
Sheet1...! I would like to declare Sheet1 in a third place
which both my Workbook and XLA know. Probably I have
missed something simple but can this be done in some way?
Best regards
/Niklas


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com