Require Formula
Closed
desai bandhu
Posts
1
Registration date
Friday December 13, 2013
Status
Member
Last seen
December 13, 2013
-
Dec 13, 2013 at 05:50 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 14, 2013 at 11:53 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 14, 2013 at 11:53 PM
Related:
- Require Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 14, 2013 at 11:53 PM
Dec 14, 2013 at 11:53 PM
suppose you are entering data in column A sheet 1 which you want to change to multiplied by 100.
rightlclick the tab of sheet and click view code.
in the resulting window copy this EVENT CODE
rightlclick the tab of sheet and click view code.
in the resulting window copy this EVENT CODE
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then GoTo enableevents 'modify if necessary
On Error GoTo enableevents
Application.enableevents = False
Target = Target * 100
enableevents:
Application.enableevents = True
End Sub
