How do I call macro depending on which textbox the user fills in?

[shuxin]

I'm trying to write a code where if the user inputs text in TextBox1 only then clicks a command button called Assign, macro1 called SOLVER will be run and if they input text in TextBox2 only then click the same command button called Assign, macro2 called sms will be run but I'm not sure how to do it. Thank you!


macro1:

Please Login or Register  to view this content.

macro2

Please Login or Register  to view this content.

[Kaper]

Are these textboxes in userform, or in the worksheet?

Basically: in a code associated with the assign button you shall check the conmtent of both textboxes. If the box 2 is <>"" then

Please Login or Register  to view this content.

if box 1 is not empty - call solver (by the way, I'd use different name for this procedure, like run_my_solver or something like that, to make it unique )

[shuxin]

Hello, thank you so much for your reply. My textbox is in the userform, I tried "If Textbox1.Value <> Then" but it says there is an error. May I know if you know how I can fix it? Thank you!

[Kaper]

File as an attachment probably would be quite useful, byt at first try

Please Login or Register  to view this content.