View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
LesioB1 LesioB1 is offline
external usenet poster
 
Posts: 3
Default some simple (?) simulation



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:
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" wrote in message
...
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