Using a code snippet multiple times in vba excel

Question

My problem is that I've a String variable strTemp5. I just want to give it a value once in my public sub and then use it in 33 normal subs. But it appears that I've to define it everytime right now. Is there any way I can use the same String by only defining it once.

Declare it as a PUBLIC variable in a module. INTERESTING READ — Siddharth Rout
– Siddharth Rout, Commented Sep 21, 2013 at 5:00

Siddharth Rout · Accepted Answer · 2013-09-21 09:19:11Z

1

If it's only ever the same value.

Public Const <variable> as <type> = x

Example.

Public Const numberofbats as Long = 6

edited Sep 21, 2013 at 9:19

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

answered Sep 21, 2013 at 6:12

user2801423

111 bronze badge

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

Collectives™ on Stack Overflow

Using a code snippet multiple times in vba excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related