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