Calling naother macro in Sub Procedure failed

Hi,

I have written the code in VBA wherein it will update values on User excel sheet automatically when button is clicked. This macro runs fine when I assign it to individual button and run it but when I call this macro in another sub procedure , then I t does not work finely.

Please give me the solution for this now.

Please Login or Register  to view this content.

When I assign Run macro to a button , then it does not work . Also Run macro has other 55 lines of the code in it . I want to assign this run macro to a button and run both macros viz Run and MAin12 one by one.

Rquest your help









Regards,
Chetan Chavan

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are still new here, I will do it for you this time.)

I have already made the changes, as you can see just by looking at your opening post. I am not able to answer your question - you will need to wait PATIENTLY for someone who can.

Please update your Excel version in your forum profile - 501 is not a recognised version.

What exactly does "not working" mean?

Not really - it's only been 14 minutes since you last posted!

We don't do 'urgent' here - any help you get is discretionary and completely free of charge, so members will step in only if they feel they can and have time to do so.

You have NOT updated your profile, as I requested in post #7, and you have not provided a workbook with the problem macro, so there is very little to go on. This is probably why you have not yet had a solution. We are not crystal ball gazers.

Yes, indeed, and three people have tried to help. Now I am asking you to provide more information, as they clearly can't help you as it stands. If you are unwilling to do so, then you can expect there to be no further offers of help. The ball is in your court: just repeating that you need help is not enough.

As you mentioned there is other content in Run macro

Originally Posted by chetanhm

... Also Run macro has other 55 lines of the code in it . I want to assign this run macro to a button and run both macros viz Run and MAin12 one by one.
...

Then there is a chance that one of this 55 lines terminates further execution of macro with something like

Please Login or Register  to view this content.

etc.

So my proposition is:

Please Login or Register  to view this content.

and assign CallBothRunAndMain12 to the button.

BTW. posting whole code of Run, not to mention the attachment with a file would shorten this thread to probably some 2-5 posts. It's just wasting the time of people who volunteer to help

See this part of my previous answer

Originally Posted by Kaper

... posting whole code of Run, not to mention the attachment with a file would shorten this thread to probably some 2-5 posts. It's just wasting the time of people who volunteer to help

See yellow box at the top of page.

Have you really tried the below? If Run and Main12 work if called separately (in that sequence) they shall in 99.9999% work also when called by CallBothRunAndMain12

Originally Posted by Kaper

Please Login or Register  to view this content.

and assign CallBothRunAndMain12 to the button.

and it's you who need the solution. So some work could replace confidential data with dummy data. It was my last advice if you don't have a will to collaborate. Bye!

How can you expect to get help when you refuse to cooperate?

1. I have asked you TWICE to update your forum profile. 501 is NOT a valid Excel version - please change this to show what you are using.
2. You have been asked for a SAMPLE workbook with DESENSITISED data - this requires a bit of effort on your part, but needs to be done.

1. Update your profile as requested.
2. Provide a sample workbook as requested.

SAMPLE does not mean real.

If you do not want spend your (precious) time preparing sample worbook with dummy data just don't use our time but hire a consultant and sign the NDA with him/her.

Bye!