VBA shorthand for x x 1

Question

Sub btn1 Click   Static value As Integer value   value   1 MsgBox value End Sub   I swear when I was taking a VB net course in college there was a shorter way to tell a variable to add    to itself  Maybe x  1  I am using Access now though instead of visual studio  When I try that within the VBE it removes the    I even removed Option Explicit with no change  Assuming the answer will be no  there is no way to short-hand it  amp  its just a peculiarly of VBA

User · Answer

If you want to call the incremented number directly in a function, this solution works bettter:

Function inc(ByRef data As Integer)
    data = data + 1
    inc = data
End Function

for example:

Wb.Worksheets(mySheet).Cells(myRow, inc(myCol))

If the function inc() returns no value, the above line will generate an error.

User · Answer

Sadly there are no operation-assignment operators in VBA   Addition-assignment    are available in VB Net  Pointless workaround  Sub Inc ByRef i As Integer     i   i   1   End Sub     Static value As Integer inc value inc value

[vba] VBA shorthand for x=x+1?

Examples related to vba

Examples related to ms-access