| Can I use your components directly within Excel as built-in functions? |
|
Yes, it is possible to do this. For some components such as Options/X, we have supplied wrapper functions which enable the methods to be called directly in Excel cells.
In the Excel examples, it is shown in one of them, how to use a number of the available functions within the VBA code. That is, in the Function demo, there are a number of simple VBA wrapper functions that wrap the corresponding Options/X methods. These functions show how to effectively call the Options/X methods directly from within the cells of Excel spreadsheets like the built-in functions, however there are a few points to take into account with this approach:
- Not all Options/X methods may have wrapper functions written for them. However you should be easily able to extend the wrapper functions as required by checking the existing methods and functions.
- The true advantages of the Options/X control is more easily obtained by using the methods directly in VBA code instead of only using the function wrappers.
The COM Add-In shows the way to use Options/X more directly within VBA code.
If you wish to create new Excel or Access applications, take a look at the way in which the Options/X control is used within the Excel and Access demos. Full source code for each of them is included in the Demo Applications directories.
|
| Visitor Comments |
|
No visitor comments posted. Post a comment
|
| Related Questions |
|
No related questions were found.
|
| Attachments |
|
No attachments were found.
|