Value of Public Constant From Concatenate strings

**exceere** · 11-11-2014, 05:14 PM

Hi,

i have these public constants:

Please Login or Register  to view this content.

and this sub:

Please Login or Register  to view this content.

when i call ShowPage sub by

Please Login or Register  to view this content.

i Get: (Sh10PegRows , Sh11PegRows).

How can I get the value of constants (100, 200) instead of the strings?

**romperstomper** · 11-11-2014, 05:23 PM

First question: why?

You would need to use a class module with the constants in, then create an instance of the class so that you can use CallByName and pass the name of the constants as strings.

**exceere** · 11-11-2014, 10:17 PM

Hi, romperstomper:

thank you for your replay...

these classes modules is just for describe what i want, which, how can i return the value of pre-defined constant if its name is stored in string variable.

For example: VarString = "Sh10PegRows" , which: Sh10PegRows is a public constant that has a value, so i want to get the value when i use the VarString in my classes.

**shg** · 11-11-2014, 10:23 PM

Or you could put them in a dictionary or collection and retrieve them by name (key), but then they wouldn't be constants.

**exceere** · 11-11-2014, 10:44 PM

Hi, shg

thank you very much for your replay

your idea is very good but it takes more time, because i have a lot of pre-defined constants used in a lot of modules, so i need to change the whole structure of my project.

**romperstomper** · 11-12-2014, 02:26 AM

You still didn't say why you would need to do this? (only that you do)

**exceere** · 11-12-2014, 05:24 AM

why i use separated module that contains my constants?

because i use it in many modules and macros

So that when i change the value of the constant, it will change in all modules.