some simple (?) simulation

[LesioB1]

Hi,
do some know how to simulate in VBA operation known in C as ++i, it's
mean add to the same variable

The Best

Lesio

 

[Per Jessen]

Hi

Maybe i = i + 1 ?

Regards,
Per

 

[Nigel]

There is no direct equivalent, but just use

i =i+1

2 extra characters

 

[Mike H]

Perhaps

i = i + i

Mike

 

[LesioB1]

Per Jessen pisze:

Hi

Maybe i = i + 1 ?

Regards,
Per

Per
in above (describe by you) case you get implade on recurrence call and
this is the point.

LesioB1

 

[RB Smissaert]

Not sure what the purpose of your idea is, but how about:

Sub PlusPlus(lVar As Long)
lVar = lVar + 1
End Sub

Sub test()

Dim i As Long

PlusPlus i
MsgBox i

End Sub


RBS

 

[LesioB1]

HI
ok I try to explain in more details:
The case is: in cell A1 there is value. In the next cell B1 I try
insert function which check this value and if the condition is True try
to increase it by 1 ( if A1 < X then ++A1). There is some kind of counter
Excel complain about recurrency.

regards
LesioB1

RB Smissaert pisze: