how to loop throughout specific sheets on userform instead of one sheet

[abdo meghari]

Hi,
I would change code to make it loop throughout sheets("PURCHASE","MAIN","DATA")
instead of sheet one is "PURCHASE" as show in this line

Please Login or Register  to view this content.

here is whole code

Please Login or Register  to view this content.

thanks

[6StringJazzer]

It's not clear what you want to do. This line of code is in UserForm_Activate, which is executed once when the form is first loaded. All it does is assign to the variable a a value taken from the sheet. If you loop through three sheets, the result is going to be that a has the value from sheet DATA. This defeats the purpose of using a loop.

Please give us a more complete explanation of what you want to do, instead of what you think the code should be.

[Kaper]

But this code:

Please Login or Register  to view this content.

is called during the activation of the form, and then values of the array a are used during actions after chcnging any of 3 textboxes to fill the Listbox with "modified" content of Purchase sheet (at the moment)..

So ... how this looping shall be used - may be it shall be located within FilterDAta procedure, not in form activation?

[abdo meghari]

when loop for three sheets I suppose to brings data from three sheets instead of one sheet.

So ... how this looping shall be used - may be it shall be located within FilterDAta procedure, not in form activation?

FilterDAta procedure depends on variable a where set is in UserForm_Activate so the change will be in UserForm_Activate.

[6StringJazzer]

I see after reading Kaper's post that a is treated as an array elsewhere in the code. I focused on the line of code you pointed out. A comment on the Dim statement would be wise. Actually comments everywhere would be wise because your other variables have rather cryptic names.

It is not clear how you want to populate the array. Your code references 1-7 as values for the second dimension of a. The line of code you showed will result in a two-dimensional array of values taken from the sheet, and it could be more than 7 rows. Also you will need three dimensions to do this for three sheets.

I'll repeat that we need to know what you want to do.

[abdo meghari]

I'll repeat that we need to know what you want to do.

actually I don't know what you want to know!
all of sheets will be same structure what implement for one sheet as in original code should implement the others sheets.
the code should populate data in listbox for 7 columns for all of sheets when write in textbox1,2,3 based on column 4,5,6 consecutively .

[JohnTopley]

Posting a sample file will help.

[bakerman2]

Give this a go.

Please Login or Register  to view this content.

[abdo meghari]

perfect!
thank you so much ,bakerman.
thanks guys for trying to help me.

[bakerman2]

You're welcome and thanks for rep+.