Need help on an excel if/then in Macro [Solved/Closed]

Report
Posts
2
Registration date
Thursday March 18, 2010
Status
Member
Last seen
March 19, 2010
-
Posts
2
Registration date
Thursday March 18, 2010
Status
Member
Last seen
March 19, 2010
-
I'm trying to create an If/Then in Macro for a cell which you input what GPM you want to use. The goal is to stop sales people from making errors and writing in too small of a GPM in the sales write up if working quickly. Say I want the minimum useable GPM to be 6% (not an actual figure, just example), but when a sales associate enters 5% (or less) by accident it automatically changes it to 6%.

If I'm doing it right the if/then statement is: =IF(G612<.06, .06)

But I can't get this to work for me in the way i want it to as mentioned above, or I just don't know how to use Macro. Can anyone help?

TIA

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
I presume your column of interest is column G

right click the sheet tab and click view code
in the window that comes up copy paste this EVENT CODE

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> Range("G1").Column Then Exit Sub
If Target < 0.06 Then Target = 0.06

End Sub

and save the file

In column G now enter some value <.06 e.g. .03 see what happens to that cell enter more than .06 in some cell in column G. what happens?

give feedback
Posts
2
Registration date
Thursday March 18, 2010
Status
Member
Last seen
March 19, 2010

That worked, thank you so much!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!