ControlSource = MyFunction()

A

Albert

Hi, Can I use Private Function that is in form module as ControlSource of
text box in that form ?

I try with 2 private functions ,First one has no argument and return fix
integer while the second one has 1 argument and return string. Result is
different. I use the first one without any problem. But the second one
returns #Name error in the textbox unless I move that function to Module and
change from Private to Public function.

Because result is different, so I not sure what is wrong.

Regards,
Suntisuk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top