Need help on an excel if/then in Macro
Solved/Closed
Gman24
Posts
2
Registration date
Thursday March 18, 2010
Status
Member
Last seen
March 19, 2010
-
Mar 18, 2010 at 05:11 PM
Gman24 Posts 2 Registration date Thursday March 18, 2010 Status Member Last seen March 19, 2010 - Mar 19, 2010 at 10:36 AM
Gman24 Posts 2 Registration date Thursday March 18, 2010 Status Member Last seen March 19, 2010 - Mar 19, 2010 at 10:36 AM
Related:
- Need help on an excel if/then in Macro
- Spell number in excel without macro - Guide
- Gif in excel - Guide
- Macros in excel download free - Download - Spreadsheets
- Marksheet in excel - Guide
- How to open an excel file in notepad - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 18, 2010 at 10:22 PM
Mar 18, 2010 at 10:22 PM
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
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
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
Mar 19, 2010 at 10:36 AM