How to upgrate changes in lisbox selection

inactiveUser214710

Board Regular
Joined
Apr 27, 2012
Messages
171
hi every one
The goal of this project is be opotunity to change some data in several columns of the userform, by selecting any row in listbox.

The changings goes to other listbox(Listbox2 = for just one regist), to be check, and after that to be saved. .

The code that I have for show in listbox2 the row select, to change is:

VBA Code:
Private Sub ListBox1_Click()  ´the data list have +- 500 rows
  Dim i As Long
   With ListBox2
    .Clear
    .AddItem   
      For i = 0 To 6
       .List(.ListCount - 1, i) = ListBox1.List(ListBox1.ListIndex, i)
      Next i
  End With 
End Sub

But as there are many regists, I agrouped and put it in combobox, to be chose the group. so the data in listbox1, comes from combobox item.
The problem is, when I choose a selection of the group of data, listbox2 don't upgrate.
Here Is the problem, it don't upgrate, the changes.
I already have tried, in many ways, to solve this problem, but without resolution. So I return to this forum to ask for help again.
For those who want and can help, I will be very grateful.
Thank You
Jdcar
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,214,965
Messages
6,122,496
Members
449,089
Latest member
Raviguru

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top