how to activate selected sheet

dear all,
good day

here below you will find an extract of my userform .
everithing works good execpt the activation of that precise worksheet.
if i use the userform inside the selected sheet it works fine,when i try to use it referring to another sheet i get stack .
i have try different way but no one is working fine :

Please Login or Register  to view this content.

Hi Lorenzo
Assuming this is referring to the current workbook & only the one workbook is open & assuming that worksheet "744 OCV PMC" is Sheet 1, I would add a Dim for the worksheet, set it as Sheet 1 & refer to it with a with statement like the example below. I normally set my sheets by number so I can rename them without having to change any VBA code. Using Activesheet & Activeworkbook can lead to all sorts of unwanted problems, it's best to qualify them by name & refer to the name in the code

Please Login or Register  to view this content.

Hope this helps

Dear all,

tks for help but unfortunately problem persist .

basicaly when i open the user form from the sheet i need to chk it works.
when i open the user form and try to chk other sheets i get a debug on the line of the sheet i want to chk with below statement:
"unable to match property of the worksheet function class".
as suggested by skywriter i have attched my worksheet.
many tks


tks to all for help

dear skywriter,sorry...my english is also poor ..... i wll try to explane :

when you opn the workbook go to the sheet called"master" ,push the only button you have and the userform will popup.
fill all the 4 x combobox (choose casually) then hit button "calcola" (calculate) ..at that point i have trouble because the function do not activate the sheet i need to chk into(all other sheets are the diffenrent tipe of table the userform need to refer based on all 4 x combobox selection).
each of that combobox option once selected should refer and activate a precise sheet (this is the point i need as selected sheet is not activating)and then will chk the table and give you the result with a msgbox
..hope now is a bit more cleare ...tks again for your patience....

Dear skywriter,tomorrow at work I wll chk.....cells a1650 and a1651 should change based on the combobox selection.....the data that you have there are my past tentative based on the combobox selection.....2x combobox selection goes there....than that value is match inside the table at the top......I also need to add a function that wll clear that cells after the user form is closed.....in the meantime tks to all for help...I let you know tomorrow...best regards

Yes sure .....many many tks ..most probably Will be another thinks I wllneed to fix tomorrow .....again tks you both guys for yr professional help..appreciated so much

dear Nori,skywriter

based on your suggestions i have modify the codes .
now it works perfectly for all things except one .
"only" when selecting from combobox (first left top one) "748 all" and select then from
the second combobox "prf" i get a bug and the combobox 4 will not populate .

here attchd the code ,highlited in red where i get the error:

Please Login or Register  to view this content.

for your reference i have attached the new sheet with the changes i have made ....tks again

dear guys,

just now solved the problem...i don't know why but renaiming that sheet with a different name make it works .
all ok now ...i wll close the post.....would like to say big thk to skywriter and Norie for their precious help .
have a good day

rgds
Lorenzo