Whenever I focus on a specific cell, and if that cell contains a value less than 2, then the content in that cell should be multiplied by 60.
By the way, I can focus to a specific cell by using the navigation keys or clicking on a partiuclar cell or anything.
For example, I focus on a specific cell with a value of 1.5. Then, my VBA program should automatically convert that cell value to 90 in the format of 60*1.5 = 90.
I know very little about programming in Excel. I cannot open most websites due to company security policies.
Can anyone help me!
1> Gary’s Stude..:
Assume the cell in question is CellB9. Place the following event macro in the worksheet code area:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim B9 As Range Set B9 = Range("B9") If Intersect(Target, B9) Is Nothing Then Else If B9 <2 Then B9 = 60 * B9 End If End Sub
Because it is worksheet code, it is easy to install and use automatically:
Right-click on the tab name near the bottom of the Excel window
Select View Code – this will open a VBE window
Paste the content and close the VBE window
If you have any concerns, try it on the trial worksheet first.
If you save the workbook, the macros will be saved with it. If you are using a version of Excel after 2003, you must save the file as .xlsm instead of .xlsx
To delete a macro:
Calling up the VBE window as described above
Close VBE window
To learn more about macros, see:
To learn more about event macros (sheet code), see:
Macros must be enabled for this to work properly!