Hi,
New on here and really need someone to help concerning this.
I have a Userform that has a combobox which is picking up values in my admin sheet for stock.
I am okay with VBA but do not have a clue how to include the combobox where you can choose the product and then either add a value or take one away.
This is the code I have so far but adds value to the whole range not the individual product cell.
Code
Private Sub AddVal_Click()
For Each r In Range("C2:C300")
r.Value = r.Value + 1
Next r
End Sub
Private Sub Allocatestock_Click()
For Each r In Range("C2:C300")
r.Value = r.Value - 1
Next r
End Sub
Private Sub Cls_Click()
Stockform.Hide
End Sub
Display More
I have attached the sheet, any help would be amazing thank you.
Thank you in advance.