sharing VBA variables between excel sheets

Question

I have one sheet with VBA code with many variables and constants and I would like to use those variables even in VBA code of another sheet. Unfortunately code is split between sheets and requires shared variables and constants as input parameters. Is it possible in VBA for excel?

You should declare the variable in module level .. as Public — matzone
– matzone, Commented Aug 1, 2013 at 7:17

LS_ᴅᴇᴠ · Accepted Answer · 2013-08-01 07:45:23Z

1

Yes, you must declare variables as Public variable [As type]. As @matzone said, at module level, i.e., before any subs, functions or properties.

In case of variable duplication you must refer to it as module.variable, where module is module code name as Sheet1 or ThisWorkbook.

Consider also the option of inserting a module in your VBA project to join all those shared variables (and functions, subs).

answered Aug 1, 2013 at 7:45

LS_ᴅᴇᴠ

11.2k1 gold badge27 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ChrisMM · Accepted Answer · 2020-01-27 16:49:05Z

0

Public token As String can access from other sheets, here token is variable

edited Jan 27, 2020 at 16:49

ChrisMM

10.1k19 gold badges41 silver badges60 bronze badges

answered Jan 27, 2020 at 16:20

Manga Rao

864 bronze badges

Collectives™ on Stack Overflow

sharing VBA variables between excel sheets

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related