I have a set of workbooks, each containing three sheets, each of these sheets with a different picture. The idea is that the pictures are imported to a template worksheet (in a stand alone book) based on the value of a variable. I can open the 'picture' books, copy the pictures and paste them...
Is it possible to have a multi column dropdown control in a custom toobar in Excel?
At the moment all I can fill it with is a single column of data by using the additem method.
Here's an excerpt from the code where ControlArray() returns an array based on the the control.
Set...
Please help. I need to create an HTML body for a Lotus Notes mail from VBA. I can get as far as creating the Notes Mail document, constructing the HTML fragment and inserting the HTML fragment in the document. However, the HTML fragment is showing as an HTML fragment and not as the lovely...
Thanks for that. I've ended up using a custom function set as the List Box's RowSourceType (ie. RowSourceType - ListArray) which seems to work pretty well:
Public Function ListArray(fld As Control, id As Variant, row As Variant, col As Variant, code As Variant) As Variant
Dim ReturnVal As...
I want users to be able to select values in a multi column list box and pass them to a blank list box so as to build up their own values in their own list box from the base list. I then want to create a table from their selections.
I can get the results into a suitable array, but cannot pass...
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.