Hi Team,

I need your help in creating a user form.

Here is what I'm looking for.

I have some  brands in Range("B1:B5") in Sheet1 and are in the order as below
Brand1
Brand2
Brand3
Brand4
Brand5

and some brands are present in sheet2 in the order different than sheet1 like

Brand5
B3
Brd2
Brand_4
Brnd1

Now I would like these two to appear in a user form side by side like

          Brand1                     Brand5
          Brand2                     B3
          Brand3                     Brd2
          Brand4                     Brand_4
          Brand5                     Brnd1

Later I would like to use mouse for re-arranging the brands at second
column i.e. like dragging and dropping, so that  the output looks like

          Brand1                        Brnd1
          Brand2                        Brd2
          Brand3                        B3
          Brand4                        Brand_4
          Brand5                        Brand5

I hope this is possible, please help me with this.

Thank you in advance.

Best regards,
Amar

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

Reply via email to