ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List Listbox items in column by macro (https://www.excelbanter.com/excel-programming/440675-list-listbox-items-column-macro.html)

K[_2_]

List Listbox items in column by macro
 
Hi all, I got two listboxes on a spreadsheet and in those listboxes I
got data like (see below)

Listbox1 Listbox2
XX AA
VV XX
AA SS

etc………..

I need macro on a button which should match listbox1 items with
listbox2 items and then list matched items one time in column A and
list unmatched items as normal in column A. So the result in column A
should look like as below

A………..col
XX
VV
AA
SS

Please can any frined can help me on this.


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com