I want to add a % discount button to one of my forms. My prices are located in G9:G18 and if a % discount is to be given Its inputed into I3. Anyone have a quick idea how to trans late that into VBA? Thanks
that works but I need it to apply to range G9:G18.... im trying the following, but not working either
Private Sub CommandButton2_Click()
Dim x As Integer
x = I2
If Range("G" & ActiveCell.Row) > 0 Then
Range("G" & ActiveCell.Row) = Range("G" & ActiveCell.Row) * (1 - Range("I2").Value)
I thought this would be easy to do, but sometime the esiest things are the toughest.