ListBox Data Update

[nidhipatel]

my userform1 contain 4 TextBox ,1 listbox, 2 command button
TextBox1
TextBox2
TextBox3
TextBox4

listbox1 contain 4 colmun and head name is Doc No, Date, Center, Rate

command button1 for TextBox Data transfer to listbox1
command button 2 for Update Listbox data

now
suppose i all 4 Textbox data tranfer to listbox1 and i need edit some listbox1 data

1 when i double click any data of listbox1 then those data show in all four textbox
2 after show all data in textbox then data edit and click command button2 for update data
data wil update and show in listbox1
how it made with vba excel macro

 

[Saurabhj]

Hi Nidhi,

Is the listbox showing data from excel sheet on loading of user form ?

Is Doc No. contains unique data ?

-Saurabh

 

[nidhipatel]

Hi Nidhi,

Is the listbox showing data from excel sheet on loading of user form ?

Is Doc No. contains unique data ?

-Saurabh

No listbox data didnot show from excel sheet
yes doc number is unique data

 

[Saurabhj]

No listbox data didnot show from excel sheet
yes doc number is unique data

From where you are displaying data in Listbox?
After editing the data, where is the data stored which you would like to update ?

To display selected data from Listbox to Textbox you can use below code. (lstDetails is ListBox name)

Private Sub lstDetails_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
       txtDocNo = lstDetails.List(lstDetails.ListIndex, 0)
       txtDate = CDate(lstDetails.List(lstDetails.ListIndex, 1))
       txtCenter = lstDetails.List(lstDetails.ListIndex, 2)
       txtRate = lstDetails.List(lstDetails.ListIndex, 3)
End Sub

Same code using WITH statement:

Private Sub lstDetails_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    With lstDetails
       txtDocNo = .List(.ListIndex, 0)
       txtDate = CDate(.List(.ListIndex, 1))
       txtCenter = .List(.ListIndex, 2)
       txtRate = .List(.ListIndex, 3)
    End With
End Sub

 

[nidhipatel]

perfect answer sir
thanku very much

 

[Saurabhj]

Thanks for the feedback.

You can learn VBA using this Video.