Multicolumn ListBox

[pankaj2610]

Hello,
After updating information in Userform3 & Userform2 the Listbox need to be updated with all fill in information. But with current attachment the listbox update/ show only 10 columns instead of 13 columns. Can expert help to sort out this problem.

[pankaj2610]

Can any expert help out to sort this problem

[pankaj2610]

Dears Request a help on this can anybody share the experience to sort out this problem

[john55]

try this

Private Sub UserForm_Initialize()
'for userform2
ListBox1.List = Sheets(2).Range("A2:m100").Value 'change here for yr needs
End Sub

[pankaj2610]

Excellent John, its working ur genius, can I request for some more help in column four getting some symbol, I am unable to track from were it is coming. Also I would like the ListForm to show grid lines is it possible. Attaching herewith excel sheet.

[john55]

sorry, not that I know of.
edit: attached test file-you can use ListView, hope it helps you!

[Sean Thomas]

it is the = sign after the number in sheet 2 column D

[pankaj2610]

it is the = sign after the number in sheet 2 column D

Thanks a lot, it is th perfect answere to my question. But the listbox is showing all the information available in sheet 2. Instead of this it should show information related to contract number only, which is shown in Textbox16. The other purpose is that once the user select the contract number & fill all the information in Userform1 & UserForm2 & press the enter command button the information need to updated in listbox also & show the recent change information in list box.
Presently the information in Listbox is updated after reopening the userform. Attaching herewith previous excel sheet which shows the update in listbox once Enter command button is press. Also attaching herewith the updated excel sheet which need the same change.
Thnaking you in anticipation.

[pankaj2610]

Thanks a lot, it is th perfect answere to my question. But the listbox is showing all the information available in sheet 2. Instead of this it should show information related to contract number only, which is shown in Textbox16. The other purpose is that once the user select the contract number & fill all the information in Userform1 & UserForm2 & press the enter command button the information need to updated in listbox also & show the recent change information in list box.
Presently the information in Listbox is updated after reopening the userform. Attaching herewith previous excel sheet which shows the update in listbox once Enter command button is press. Also attaching herewith the updated excel sheet which need the same change.
Thnaking you in anticipation.

Dear Excel Guru appreciate your response in this view

[pankaj2610]

Dears Would like to wish you all Happy New Year, Request your help on the above post, it should show only the search result, presently it is showing all the records in the sheet.

[pankaj2610]

Hello, Can anybody help to sortout the problem mentioned above & in attached excel sheet