Userform edit data

[cdkulkarni58]

Hi Everybody,
I have two userforms say form1 and form 2. userform1 is having a listbox called listbox1. the data is being populated to listbox1 from values geneated from userform2.The number of values are generated in listbox1 in form1 .My question is I need to edit the specific value in listbox1 without changing the sequence or index of the value. I go back to userform2 add the new value but i cant put it at the same location as that of earlier.

Would anybody help me out in this.

Thanks in advance

CDK

 

[Norie]

How does the first listbox drive the contents of the other listbox?

If you change something in the 1st listbox couldn't you just clear the 2nd listbox and repopulate it.

 

[cdkulkarni58]

Hi,

No the list box in first form is collecting the data from second form . The first list box is just a data collection location it does not drive form2. But I can go back to second user form from first form put the original values back to particular page of multipage in second form . edit those values (By simply changing name of command button name instead of add to edit) from 1st userform.Can add those values to first userform. But this new location is the last location in list form instead of the particular location which i want to put these values to.

Thanks in advance once again

Regards

CDK

 

[Norie]

So I got it the wrong way round?

Sorry but it was a little confusing, I'm not even sure why you have 2 userforms.

By 'drive' I meant that what was in one listbox was based on what's in another listbox.

Anyway it still isn't clear what you want to do.

You've now mentioned a multipage and a command button.

Where do they come into things?