Hello,

I've created a UserForm with listboxes:

ListBox1 loads all my open workbooks.
ListBox2 loads all worksheets in selected workbook.
ListBox3 loads data from WorkbookA starting with Range("C5") through
the complete column and when I click on data in listbox3 it inserts
data in ActiveCell of Selected Workbook.

This is what I need to do with ListBox3 load data begin with
Range("C5") through rest of rangeC but when I click on a select item
in ListBox3 I need it to insert data in activecell the data from
RangeC and RangeD data needs to go to the right of activecell.

Example:

RangeC5 RangeD5
AHU AIR HANDLING UNIT
AIR COMP AIR COMPRESSOR
AIR CURTAIN AIR CURTAIN
AIR DRYER REFRIGERATED AIR DRYER
AUTO WINDOW AUTOMATIC WINDOW OPENER
AUTOCLAVE-EL AUTOCLAVES-ELECTRIC
AUTOCLAVE-ST AUTOCLAVES-STEAM
AUTO-DOOR-EL AUTO-DOOR UNITS-ELECTRIC
AUTO-DOOR-HY AUTO-DOOR UNITS-HYDRAULIC
BOILER, HW BOILERS HOT WATER
BOILER, ST BOILER STEAM
CAB HEATER CABINET HEATER

If I select Air Comp it will insert in activecell then I need Air
Compressor to insert to the right of activecell.


Thnk you for your help,
jfcby