I want to just assign a percentage reduction on numbers placed in cells. The list box with the % (5, 10 ...) is well established and I have my number in F9. I would now like to change, I choose in my list the percentage that I would grant that the same number in F9 is adapted with the percentage requested.
Here's what I did, but I immediately 0 in F9, but if I do the result in another cell, it goes well, but this is not the goal.
Code:
Private Sub ComboBox1_Change ()
If ComboBox1.Value = "0" Then
Range ( "F9"). Formula = "= F9-(F9 * 0%)"
ElseIf ComboBox1.Value = "5" Then
Range ( "F9"). Formula = "= F9-(F9 * 5%)"
ElseIf ComboBox1.Value = "10" Then
Range ( "F9"). Formula = "= F9-(F9 * 10%)"
ElseIf ComboBox1.Value = "15" Then
Range ( "F9"). Formula = "= F9-(F9 * 15%)"
End If
End Sub
So is there a way to put this number in buffer or else?
BTW I am not in a userform! but directly on the sheet excel
Bookmarks