Populate second userform from one ListBox

[farhad]

Good Day

I am using 2 User Access forms which are called User form and Userform 1 and Userform 4 and respectively.

I have one List Box.

I would like to certain information to appear on Useform4 from the List Box.

Thanks

 

[My Aswer Is This]

We always need specific details.

You did not say:
1.What Userform the listbox is on
2.What the name of the listbox is.
3.What this

certain information is.​

 

[farhad]

Hi

There are two userforms

Userform 1 and Userorm 4

Once ListBox which is called ListBox1

ListBox1 access information for Userform 1

Both Userform 1 & 4 write information to Sheet4

The information that I need to populate onto Userform4 using ListBox1 if Range: AU:BV

Thanks

 

[My Aswer Is This]

You said:

AU:BV

That's all the data from 27 columns:
Is this a Multicolumn ListBox?

That is a lot of Data. about 40 Million cells of data
And that has nothing to do with your original post that said:

Populate second userform from one ListBox​

​

 

[farhad]

Hi

Yes is a multicolumn listbox
However I only need Range AU:BV to display on userform4 from Listbox1

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

I have never tried to load a 27 column listbox with all the values in 27 different columns.