How to identify txtbx.value

[Zygoid]

I have a userform.textbox with a subcommand _exit(MyVal......) that calls a module.

in that module I want to indentify the textbox.value of which ever textbox I call it from.

I'v tried many diffferent ways and think I am closer to my goal with application.caller but still can't get it to work.

I am getting error "sub or function not defined"

Please Login or Register  to view this content.

[Richard Schollar]

Why don't you stick to your original thread so everyone else can see what has already been suggested?

http://www.excelforum.com/excel-prog...in-module.html

If you check VBA Help on Application.Caller you will see that you can't use it as you wish as it will return an error in such circumstances...

[mudraker]

Zygoid

Please continue with your original thread

RichardSchollar
Thanks for pointing out this is a cintunation of another thread


Thread Closed