Compile error: Sub or Function not defined.

Hello,

Please Login or Register  to view this content.

I get Compile error in highlighted code. I have many such codes on the same spreadsheet under Userform1 button and it works fine. I added this code in Userform2 and I get this error message.

any idea why I am getting this error message.

Thanks

I'm assuming SheetExists is a custom vba function as I'm not aware of any built in functions of that name. Therefore the most likely error is that your custom vba function is set to private or only functions for userform1. Either add the code for the sheetexists function into the module the above code is from or declare it as a public function.

well. ? I am not good with coding. I just know tweaks of existing code. This is something new i learned today.
Could you please advise me,as to How to declare it as a public function.?

Note : Same data works fine in Userform1 but does not work in Userform2.

Thanks

I even tried to change the name of Userform2 to Userform1 , but no help.

Private:

Please Login or Register  to view this content.

Public:

Please Login or Register  to view this content.

in essence. It's hard to provide much input without seeing any of the forms/code/project...

I tried Private function as your suggested, but received some strange error message. It was a big message to type back in note pad.
Please advice.

Thanks

Change the line in the code of userform1:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and change the line in the code of userform2:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

nice!!!!

Both your code worked..

Thanks Norie
Thanks Yudlugar

Regards
Shiva