MIS Excel Tricks - 5
Private Sub Worksheet_SelectionChange(ByVal Target As Range)Cells.Interior.Color = vbWhiteDim ROW_NUMBER As IntegerDim COLUMN_NUMBER As IntegerROW_NUMBER = A...
🔥 Related Trending Topics
LIVE TRENDSThis video may be related to current global trending topics. Click any trend to explore more videos about what's hot right now!
THIS VIDEO IS TRENDING!
This video is currently trending in Saudi Arabia under the topic 'new zealand national cricket team vs west indies cricket team match scorecard'.
About this video
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.Color = vbWhite
Dim ROW_NUMBER As Integer
Dim COLUMN_NUMBER As Integer
ROW_NUMBER = ActiveCell.Row
COLUMN_NUMBER = ActiveCell.Column
For I = 1 To COLUMN_NUMBER
Cells(ROW_NUMBER, I).Interior.Color = vbBlue
Next I
For J = 1 To ROW_NUMBER
Cells(J, COLUMN_NUMBER).Interior.Color = vbBlue
Next J
End Sub
Cells.Interior.Color = vbWhite
Dim ROW_NUMBER As Integer
Dim COLUMN_NUMBER As Integer
ROW_NUMBER = ActiveCell.Row
COLUMN_NUMBER = ActiveCell.Column
For I = 1 To COLUMN_NUMBER
Cells(ROW_NUMBER, I).Interior.Color = vbBlue
Next I
For J = 1 To ROW_NUMBER
Cells(J, COLUMN_NUMBER).Interior.Color = vbBlue
Next J
End Sub
Video Information
Views
13
Total views since publication
Duration
11:27
Video length
Published
Mar 3, 2023
Release date