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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top