Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get #### when typing | Excel Discussion (Misc queries) | |||
is microsoft strong cryptographic provider encryption good enough | Excel Discussion (Misc queries) | |||
How to delete a row if strong NOT found.... | Excel Discussion (Misc queries) | |||
name typing | Excel Worksheet Functions | |||
typing #1 becomes #10 | Excel Discussion (Misc queries) |