فایل پیوست را بررسی نمایید
کد PHP:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rowNumberValue As Integer, columnNumberValue As Integer, i As Integer, j As Integer
Cells.Interior.ColorIndex = 0
rowNumberValue = ActiveCell.Row
columnNumberValue = ActiveCell.Column
For i = 1 To columnNumberValue
Cells(rowNumberValue, i).Interior.ColorIndex = 37
Next
For j = 1 To rowNumberValue
Cells(j, columnNumberValue).Interior.ColorIndex = 37
Next
Cells(rowNumberValue, columnNumberValue).Interior.ColorIndex = 4
End Sub
علاقه مندی ها (Bookmarks)