Userforms

[MAS]

Hi,

I have tow userforms

based on the combobox1.value in userform1 userform 2
activates.

then in userform2 combobox1 there category list which is
used to filter data in sheet2 and show printpreviw.
when the previw window close msgbox popup asking whether
to contnue.. when pressed yes userform 2 shows agin to
select another option from combobox1. in this second
instance when i click my command button1 (prnt previw)
nothing hapens?

while in the first instance it works properly!

what will be wrong here since i have selected the sheet
and did not change the selection to another sheet.

Is it necesary to select a sheet in order to
filter/previw etc or we can call the action from another
sheet?

Thanks

Mas

 

[Rob]

you need to select a sheet before you can set the filters
on that sheet,

the best option would be that when you return to the
userform the second time, turn all filters off, and then
turn them back on when you wish to prieview.

this should mean that the data is called when you request
the action that involves the data.