Hi Maurizio

You are missing a row source. Just include this to UserForm3 in the UserForm_Initialize() code.

With Me.ListBox1.RowSource="A2:L56"

Hope this helps.

Sunny

You will also need to change the column count to 12 and add one more column width to show all 12 columns.

'Settaggio di alcune proprietà della ListBox1
With Me.ListBox1
'Numero di colonne
.ColumnCount = 12 '<--Change to 12
.RowSource = "A2:L56" '<--Add this extra code
'Larghezza delle quattro colonne
.ColumnWidths = "0,10,10,10,10,10,10,10,10,10,10,10" '<--Add one more column width
End With

Sunny

Thanks SunnyKow Are Great, and think that both days that we work upward, I knew the problem, but I could not see it was just them.
However I tried your tip and now works wonders Thanks Infinite really, sincere greetings from A.Maurizio

Hello SunnyKow do not know if I still have time to add another application or check; or do I turn on another thread.
But the fact and that: Using this Volta a Userform4 want Recreating a sort of Field of Sheet2 search.
Now this happen to me: If I do not put the usual (On error resume next) continues to Give me a number of errors when in reality they are not errors.
If on the contrary I put (On error resume next) works but if I have a look at the top of Sheet 2 Starting from the cell (P2: AA2) you immediately realize that I wrote the last two entries in Listing (line 56) here because it behaves so and where is the problem? Thank you

(P.S)  Even in this case will I enter the Test File

Hi Maurizio

I have modified the codes for you.

See if this is what you wanted.

Sunny

Hello Dear SunnyKow listen to your project works fine, and so far I had no doubt.
But you would not get in the listbox reports of what is in line rather than in a column as rightly created you, doing so would also be more readable before you get the click no?
Thank you

I still don't understand what you want (communication problem again I think).  I am only making a guess what you wanted based on your codes. If you can explain more and give examples then maybe I can understand better. Let me know which part I did is ok and which is not correct or missed out.

Sunny

t certainly SunnyKow and sorry again for everything, but the discussion is this: If you look in the Listbox when did the research.
In the Listbox will appear all entries in column thus:
55
TO
maurizi
Musician
etc...!

While I was wondering if you can not simply have to get the whole thing in this way, Example:
55 In Maurizio Musician etc ...!
56 A Gina Lawyer etc ...!

Since A written in texbox in Listbox identifies 2
and then there would be the ability to display across the entire line in the sheet 2 from the cell (P2: AA2) depending on me to do click on the first line rather than in the second of the Listbox.
In a few words I would like to be able to view only the person that I report Click on the listbox. Thank you're just a friend

Hi Maurizio

OK, I think I know what you want.

I have done the following:

1) The Listbox will display all the records (in columns) upon initialization.

2) If you select any record in the Listbox, it's values will be populated to the range P2:AA2 and also the Textboxes on the Userform.

3) You can also search for record by Code or Name (depending on the Radiobutton selected). If the record is found, it will be highlighted (selected) in the Listbox and its values will be populated to the range P2:AA2 as also the Textboxes on the userform.

Hope this is what you want.

Sunny

Many thanks SunnyKow Fantastic because not only are you a great, but it more than I wanted to be expected really.
Thank you very much indeed Sincere Greetings from A.Maurizio

(P.S) If I could I would offer you a happy Coffee least, Thanks again for everything and the time that I have caused you to lose Hello and Happy Weekend