in the attached file, I am working on the userform "PANDL" which works pretty good but considering that I have no knowledge in VBA I am stuck with small details/bugs and I really wish someone help me.
My codes works good when I select a ref in the userform and click on print. This works good.
However I have some issues when I perform a search/filter.....
- I open the PANDL useform and then click on the binocular which opens the subform "search_pandl" which allows me to filter the datas based on month/ref/bl date.
1st problem (stupid one I know but still): I don't know when to unload SEARCH PANDL.....I tried to put it after filter, after getdata nothing does what I want......This userfom is used to input the filter criterias but once the PandL has get the datas for at least the first ref, this search Pand l form should close on the condition of course that it does not loose the criterias of the filter......
2nd problem: when the REF of the PandL form change, I should:
If no filter applied, simply get the data for the REF (this is fine)
however if a filter is applied (= after performing a search_pandl):
I want for each found ref, get the data (this is ok)
print automatically the pandL. However before printing it I want to ask the question If I really want to print the pand l for all the ref, If yes, then automatically print them one after the other without asking again
For the moment below code ask me if I want to print it each time the ref change, I want the question to be asked from the first ref found and then applied automatically for the next ones.....
can someone have a look at the file, maybe test the code and help me to sort those issues.......I am really sorry but I did all this alone picking there and there codes trying to adapt them but since i have never study VBA .... I am really stuck
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks