Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. steveroberts

    Export a picture from Excel?!?

    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...
  2. steveroberts

    Multi Column ListBox Control in a Toolbar

    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...
  3. steveroberts

    VBA / HTML / Lotus Notes

    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...
  4. steveroberts

    Populate List Box with an array

    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...
  5. steveroberts

    Populate List Box with an array

    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...

Part and Inventory Search

Back
Top