Require Formula
Closed
desai bandhu
Posts
1
Registration date
Friday 13 December 2013
Status
Member
Last seen
13 December 2013
-
13 Dec 2013 à 05:50
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 14 Dec 2013 à 23:53
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 14 Dec 2013 à 23:53
Related:
- Require Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
14 Dec 2013 à 23:53
14 Dec 2013 à 23:53
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
