adding a variable to a variable in a loop

[gtopmafia]

Hi Guys Im trying to make a Loop function for the following I want to make the payPer iterate so payPer1, payPer2 etc.

Any idea how I can do this? cheers.

pmtCount = 0
incremental = 0
x = 1
Do While pmtCount < 20
Cells(Rows.Count, 22).End(xlUp).Offset(0, 0).Select
ActiveCell.Offset(0, incremental).Select
ActiveCell.Value = payPer+(what here)
incremental = incremental + 1
pmtCount = pmtCount + 1
x = x + 1
Loop

 

[Joe4]

It is not necessary to actually select the cells, and doing so will actually slow your code down.
Try this:

    pmtCount = 0
    incremental = 0
    x = 1

    Do While pmtCount < 20
        Cells(Rows.Count, 22).End(xlUp).Offset(0, incremental).Value = "payPer" & x
        incremental = incremental + 1
        pmtCount = pmtCount + 1
        x = x + 1
    Loop

 

[gtopmafia]

Hi Cheers for help so far, I need to adapt it to somthing more like this but this isnt working, CPS is a userform, and when i do "CPS.payPer & x" it literally returns "CPS.payPer1", "CPS.payPer2" etc in the excel cell and not the value attributable for example 42.

Do While pmtCount < 20
Cells(Rows.Count, 22).End(xlUp).Offset(0, incremental).Value = CPS.payPer & x
incremental = incremental + 1
pmtCount = pmtCount + 1
x = x + 1
Loop
End Sub

 

[Joe4]

OK, that is bit different. Didn't realize "payPer" was an object on a userform.
I really don't work much with userforms. Perhaps you could implement something like this here: https://www.mrexcel.com/forum/excel-questions/1059303-loop-thru-multiple-checkboxes.html#post5087009

 

[gtopmafia]

is there a way to maybe make a loop before to generate a variable to use in the loop i posted above? maybe that would be more efficient

 

[gtopmafia]

as a side not when declaring variables how can i put the declarations on the same line can you split them with a comma or?

 

[Joe4]

is there a way to maybe make a loop before to generate a variable to use in the loop i posted above? maybe that would be more efficient

I am not sure what you mean.

as a side not when declaring variables how can i put the declarations on the same line can you split them with a comma or?

You can separate them with a comma, but note that each needs to be declared explicitly.

This is the wrong way to declare a, b, and c as Integers:

Dim a, b, c as Integer

This is the right way:

Dim a as Integer, b as Integer, c as Integer

In the first example, only c would be declared as an Integer. a and b would be declared as Variant.

 

[gtopmafia]

further comment, sorry for spam, Ive adjusted the script to make the variable payPer have a value but I still want to loop with the +1 so how would I do this?

 

[gtopmafia]

I am not sure what you mean.


You can separate them with a comma, but note that each needs to be declared explicitly.

This is the wrong way to declare a, b, and c as Integers:

Dim a, b, c as Integer

This is the right way:

Dim a as Integer, b as Integer, c as Integer

In the first example, only c would be declared as an Integer. a and b would be declared as Variant.

Ok thanks

 

[Joe4]

Ive adjusted the script to make the variable payPer have a value but I still want to loop with the +1 so how would I do this?

Once again, I am unclear what you mean. How is this different that anything we have already discussed?
If you changed anything, please post your new code and explain exactly what it is you are trying to do now.