ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ListBox drag & drop (https://www.excelbanter.com/excel-programming/311343-listbox-drag-drop.html)

GMet

ListBox drag & drop
 
I have a form with ListBox1 and ListBox2. I have the drag and drop code
from the example.

I have 2 questions.
1 - can I show grid lines in the listboxes?
2 - when I select and drag from ListBox1 into ListBox2, I want it to align
with a selected row in ListBox 1. In the example below I have selected E
from ListBox1 to drag and drop into ListBox2. I want E to align with C in
ListBox1. It would look like this:

before drag & drop
ListBox1 ListBox2
A
B
C
D
E

after drag & drop
Listbox1 ListBox2
A
B
C E
D
E

is that possible?

Glen





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

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