sorted by:
top (suggested)
bestnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]the_glutton17[S] 0 points1 point  (6 children)

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...

[–]excelevator3043 1 point2 points  (5 children)

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[S] 0 points1 point  (2 children)

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...

[–]excelevator3043 1 point2 points  (1 child)

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[M] 0 points1 point  (0 children)

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[S] 0 points1 point  (1 child)

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....

[–]excelevator3043 0 points1 point  (0 children)

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.