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 · Accepted 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

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

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

Examples related to vba

Examples related to ms-access