'excel button connected to macro having runtime issue
My vba code connected to a button is crashing on runtime. It is stating sub or function not defined. I am new to vba code so I dont know how to solve this. It appears that the method is closed so I dont know why this is not working. I have added a photo below.
Sub FormButtonClick()
With Shapes(Application.Caller).TopLeftCell.Offset(-1, 0)
.Value = IIf(Not IsNumeric(.Value), 500, .Value + 500)
End With
End Sub
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|