How to assign a ImputBox to a "Constant expression"

[capson]

From The Macro I have

Please Login or Register  to view this content.

But I want to use a InputBox to assign the number

Please Login or Register  to view this content.

But I get the error "Constant expression required" and do not know how to get around this

Thanks

The Full Macro:

Please Login or Register  to view this content.

[LJMetzger]

Hi capson,

Your following code is not allowed:

Please Login or Register  to view this content.

Constants are items that are set in stone. They can be based on other items that are also set in stone, but constants cannot take the value of a variable (even though the value of that variable will never change again).

Good try, but I think you're stuck with what you have.

Here is an example of a constant based on another constant:

Please Login or Register  to view this content.

Lewis

[capson]

Hello Lewis, thanks you for the reply, not what I wanted to see but I was afriad that would be the case.

[capson]

Lewis if I do this:
Dim iCnt As Integer

And Declare iCnt like this:

Please Login or Register  to view this content.

I get the proper exactution of the Macro

But if I Declare iCnt like this:

Please Login or Register  to view this content.

The Macro gives the wrong output

Can this be trusted to give the proper output

Please Login or Register  to view this content.

[LJMetzger]

Both your constructions work fine if the input data is valid. The 'M6' construction will give you trouble if the value is NOT a number. You probably need to employ some defensive programming techniques with that one to make sure that nothing will go wrong, go wrong, go wrong.

Please NOTE that 'Sheets(1)' always uses the sheet that is the first tab (all the way on the left). Many programmers prefer the method you use. My personal preference is to use 'Sheets("SheetX")' or whatever the actual 'Sheet Name' is.


See the following examples which use your code exactly as is (tested and working):

Please Login or Register  to view this content.

You may also want to check to make sure iCnt is in the expected range.

Lewis

[capson]

Thank you, I will implement this