A Userform comes from A and B

[rcprito]

Hey guys.

I have an userform that comes from two others userforms.

I want to make an If that If comes from A happens one thing.

If comes from B happens other thing.

Please Login or Register  to view this content.

can u help me? thanks

[hafizimran]

Declare a public variable in your form e.g.

Please Login or Register  to view this content.

then before showing form set its value...

Please Login or Register  to view this content.

then use If to check the sender name in Load event...

Please Login or Register  to view this content.

[mehmetcik]

Phew

This was awkward. I tried declaring a public variable but that didn't seem to help at all.

But I found two ways that did work.


First set a cell on a worksheet to be a flag.

Please Login or Register  to view this content.

Then you can use that flag to change the way your macro runs.

Alternatively you can use a text box or a label on the Two Calling Userforms as flags.

Setting a flag:-

Please Login or Register  to view this content.

Using A Flag:

Please Login or Register  to view this content.

Sample Spreadsheet Attached.

Enjoy.

[mehmetcik]

Sorry Just got the public variable working as well

So now you have 3 options. The Public variable being the easiest.

[rcprito]

Well it's not working for me.

Please Login or Register  to view this content.

I created the labels for each and put everything as you did.

It is only working the "Else" part.

If I put

Please Login or Register  to view this content.

and then

Please Login or Register  to view this content.

[/CODE]

only the 2nd part works.

I've switched them and only the 2nd part works.

What's the ]If Left(Extrusão.Label7.Caption, 1) for ?

Cheers, thanks a lot

[Norie]

What's do happen when the form is called from A and what's to happen when it's B that does the calling?

[rcprito]

problem solved ! solved the problem creating another userform to make it easier, thanks a lot dudes