multicolumn

  1. S

    Copy the contents of a multicolumn listbox to another multicolumn on another Userfrom

    I am trying to pass a Listbox multicolumn selection over to another multicolumn Listbox on another open Userform, but only if there is text on at least one of the source listbox columns/ I have tried listdest.additem listdest.list(listdest.listcount...
  2. J

    excel VBA: Alphabetize a multicolumn dynamic named range

    Hello Everyone, I have a multicolumn dynamic range linked to a multicolumn combobox on a userform. Am trying to find a way to alphabetize the range top to bottom, left to right as so: Col1 Col2 Col3 a h o b i p c j d k e l f m g n Can't...
  3. H

    Use Ranged Match or Countif on dual columns

    The Countif below should read something like ...partNumber & companyName, Range("MPN!PDPMPN[MFR_PART_NUMBER] & Range("MPN!PDPMPN[ORGANIZATION_NAME") to concatenate the two fields for the search. Unfortunately, MPN table columns are A and D are not consecutive. Dim company As Variant...
  4. A

    Filter UserForm Multicolumn ListBox with TextBox/ComboBox

    Hi Everyone, I've been looking for an answer to this specific scenario and I haven't found it yet. If it exists, I'm sorry for wasting your time and would request the link to that answer please. If not, here we go. I'm creating a listbox in a userform that's using a rowsource from a sheet...
  5. A

    If/then formula using multiple columns/sheets?

    I am working with two separate data sheets. One lists all the products in one column with pricing usage and vendors in columns next to it. In the new data sheet that I'm creating, I listed all the vendors in separate columns with the part numbers all in column A. I need to show (by highlighting...
  6. Erdinç E. Karaçam

    20 column in a ListBox ?

    Hi dear friends, I need load 20 columns and 5 rows data to a ListBox from a Worksheet... (The content of data from an invoice...) I have tried by AddItem and by RowSource methods but didn't worked and not useful... Could you give me a sample VBA "array" code for this please ? Thanks in...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top