ActiveX button calling VBA from another hidden tab ?

[KomicJ]

Hey guys,

I'm currently reworking a xlsm file, almost from scratch (learned so many new things eversince I started posting here that I just had to do it). But before I do, I need to make sure of one thing; is it possible for an ActiveX button, placed on sheet1, to call a VBA procedure that is placed on a different hidden sheet (results of that VBA procedure are also posted on that same hidden sheet) ?

Just want to make sure to do the right thing before I get any further.

Thanks.

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[KomicJ]

Sorry, didn't know. Adjusted.

[GC Excel]

Hi Komicj,
Sure it's possible but you the syntax is slightly different. Instead of placing your VBA procedure in your hidden sheet, why not simply place it in a Module.

For example, assuming you have an ActiveX button in Sheet1:

code in sheet1

Please Login or Register  to view this content.

code in sheet2

Please Login or Register  to view this content.

code in Module1

Please Login or Register  to view this content.

[KomicJ]

To be honest, I'm not nearly familiar enough with VBA to understand the code. I have a code that works right now (though it'll need some tweaking), but that part will probably be taken care of by someone else. I just wanted to make sure my layout was going to work for what I had in mind.

So, even if hidden, I'll be able to collect the data (it's basically a webquery), post the results on the hidden page, and use that data as reference for my other sheets...correct ?

[GC Excel]

Yes, that's correct.
It doesn't matter if your sheet is hidden or not. You can still use it read / write data to it.
I ofter use hidden sheets in my projects to store some parameters used.

[KomicJ]

Awesome, thanks a lot.
Edit: Rep added.