donnyp02
11-07-2013, 01:22 AM
Hello everyone,
I assure you I searched before posting this, everything I could find was way above my level and more complicated then what I'm trying to do. I have a form that I fill out, and want to be able to press a form button to add the fields in the form to a master list.
I'm trying to figure out how to add for instance A1 to the value of A30, and make that the new value of A30, and also clear the contents of A1 when the buttons is pressed. I even go a hold of a couple books on VBA for starters, no idea why I couldn't find something so simple. I tried doing a simple addition function but it didn't work.
Private Sub add_Click()Cells(1, 3).Value = Cells(1, 3) + Cells(16, 3)
End Sub
Thanks in advance for any assistance!
I assure you I searched before posting this, everything I could find was way above my level and more complicated then what I'm trying to do. I have a form that I fill out, and want to be able to press a form button to add the fields in the form to a master list.
I'm trying to figure out how to add for instance A1 to the value of A30, and make that the new value of A30, and also clear the contents of A1 when the buttons is pressed. I even go a hold of a couple books on VBA for starters, no idea why I couldn't find something so simple. I tried doing a simple addition function but it didn't work.
Private Sub add_Click()Cells(1, 3).Value = Cells(1, 3) + Cells(16, 3)
End Sub
Thanks in advance for any assistance!