How to do this is actually documented in the on-line VBA help for Excel (look for examples of loading combo boxes).
- You have the data in an array - good.
- Make sure the array has the same number of columns as your combo box definition, e.g., DIM sArr (1,4) as String for a 2 column x 5 row...
Does anyone know how to check, using VBA code, if a particular Reference library has been switched on in the local environment options, and then how to switch it on if not?
I have been developing some emailing functionality between MS Project and Outlook, and when I run the code on another's...
Ed,
There are many approaches to this, from modifying the MS Project database to add new data structures, through to using some external (to MS Project) data storage.
MS provides sample code on how to modify the MS Project Database (and extend your data model). See Developer Support article ...
Another approach is to generate a unique WBS template for each subproject (See Project menu/WBS) and renumber the WBS codes for each task in the subprojects.
Be sure to switch off WBS renumbering once your basic set has been defined (Project occasionally recalculates WBS codes if allowed).
I want to invoke the File Select dialogue box to help a user fill in a hyperlink field in MS Access (2000). I read stuff about the Common Dialogue (?) but trying to install the control on an access form, access says insufficient permissions are given & I need to reinstall the product.
Ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.