Assigning values to constant from userform in VBA

[ashvn]

I would like my code to take a value from textbox in the userform and use it as a constant for declaring values to other function for eg

Const i1max=userform1.textbox1.value

dim sys(1 to i1max) as computertype

I am getting a compilation error stating that constnt variable should be defined explicitly.

Is there any possible solution to overcome this problem

 

[RaulARodriguez]

Remove the Option Explicit statement from your code or set a default value for your constant then let it vary using the textbox.
When you use the Option Explicit statement, you must explicitly declare all variables using the Dim, Private, Public, or ReDim statements. If you attempt to use an undeclared variable name, an error occurs

 

[Mike LH]

Hi,

A constant by definition has to be just that so AFAIK there's no way to declare a constant in that way or by using a cell value.

 

[V_Malkoti]

It needs to be a constant value, not something that can change.

expression
Literal, other constant, or any combination that includes all arithmetic or logical operators except Is
You can't use variables, user-defined functions, or intrinsic Visual Basic functions (such as Chr) in expressions assigned to constants.