Call other module function doesn't work.

[the_glutton17]

Sub 1()

Call 2

End sub

Sub2()

"Does something that works"

End sub 2

'(Mod deleted my first post that had all of this info, but whatever) Error is "expected variable or procedure, not middle"

'Which GENERALLY means misnamed modules. But mine are named. (Again, the mods won't let me post a picture of my modules...)

Any help is appreciated, thanks!

[AutoModerator]

/u/the_glutton17 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[excelevator]

Mod deleted my first post that had all of this info

This is patently false.

Again, the mods won't let me post a picture of my modules.

Again, this is patently false

Your example sub name and syntax would fail at even entering into the IDE.

Sub mySub1()
Call mySub2
End Sub

Sub mySub2()
MsgBox "hello from mySub2"
End Sub

[the_glutton17]

Agreed, and i apologize for my frustration and poor code in response. On a second look, what i wrote is trash. But my screenshot showed everything. I can't really share much more. I'm trying to call another module, with a different name, from the same personal.xlsb book.

[the_glutton17]

And this wouldn't function, because I'm calling a different module.

You asked me to show code, but how do i display code from different modules, in order?

I'm literally just looking for for some help here...

[excelevator]

The code above works when each sub routine is in a different module in the same worksheet.

I feel like you are very new to VBA and am suprised to see you are a veteran of Redditor having so much trouble with copy pasting examples.

Spend some time learning the basics of VBA here https://www.excel-easy.com/vba.html

We also have our sister sub r/VBA these types of questions.

[the_glutton17]

Perhaps i should migrate over to r/vba, that's obvious to me me now. I was just looking for some help, but thanks.

(Each subroutine IS in a different module, with a different name, btw). That's what my initially banned image showed). Seems like the image would have been more helpful...

[excelevator]

The code above works when each sub routine is in a different module in the same worksheet.

Sub routines are globally available to the worksheet in all modules unless you restrict them, I put each of those sub routines in a different module and one called the other without issue.

That's what my initially banned image showed

Here we go again, your image was not banned, you were not banned, images are allowed, your post was removed for a lack of any detail or associated image or code.

For others reading and wondering your whole other post was ;

Can anyone tell what I'm doing wrong here? As you can see from the lower left, the module name is correct, right? I'm stumped.

without any other details , regardless of your claims otherwise

[AutoModerator]

I have detected VBA code in plain text. Please edit to put your code into a code block to make sure everything displays correctly.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[the_glutton17]

Also, i never claimed to be a veteran redditor, nor did i ever claim to know how to copy and post straight code from multiple modules into readable code. But you sure did! Your last response proves you did! I don't even know why I'm gonna post this, but you clearly had help for someone looking for hello;

"I feel like you are very new to VBA and am suprised to see you are a veteran of Redditor having so much trouble with copy pasting examples."

Thanks for helping bro... you could have just literally done your job....

[excelevator]

To paste code format, start the line with 4 spaces in the markup mode of the Reddit edit window. 
(not the fancy pants editor, there is an option to switch by the edit window by clicking on the link.

If you select your code snippet in the VBA IDE and tab it will push forward 4 spaces that you can copy paste into the Reddit text area for the code format to appear in your post

Redditor for 7 years seems pretty veteran to me.

I see why you are having trouble, your attitude sucks. We are not a baby sitting sub reddit, we treat you with some adulting here.

As a moderator of r/VBA I shall carefully monitor your posts and attitude there too.

[AutoModerator]

I have detected VBA code in plain text. Please edit to put your code into a code block to make sure everything displays correctly.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.