Moderatori: Anthony47, Flash30005
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Target.Cells(1, 1), Me.UsedRange) Is Nothing Then
Me.UsedRange.Interior.Color = xlNone
Application.Intersect(Target.Cells(1, 1).EntireRow, Me.UsedRange).Interior.Color = RGB(255, 255, 0)
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Warr, StRange As String, tVal
Dim i As Long, j As Long
If Not Application.Intersect(Target.Cells(1, 1), Range("Colora")) Is Nothing Then
tVal = Target.Cells(1, 1)
Warr = Range("C11:G200").Value
For i = 1 To UBound(Warr)
For j = 1 To UBound(Warr, 2)
If Warr(i, j) = tVal Then
StRange = StRange & "," & Range("C11").Cells(i, j).Address
End If
Next j
Next i
If Len(StRange) > 3 Then
Me.Range(Mid(StRange, 2)).Interior.Color = Range("H1").Interior.Color
End If
End If
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address = "$H$1" Then
Range("C11:G2000").Interior.Color = xlNone
Cancel = True
End If
End Sub
Private Sub Worksheet_SelectionChangea(ByVal Target As Range)
If Not Application.Intersect(Target.Cells(1, 1), Me.UsedRange) Is Nothing Then
Me.UsedRange.Interior.Color = xlNone
Application.Intersect(Target.Cells(1, 1).EntireRow, Me.UsedRange).Interior.Color = RGB(255, 255, 0)
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Warr, StRange As String, tVal
Dim i As Long, j As Long
'
If Not Application.Intersect(Target.Cells(1, 1), Me.UsedRange) Is Nothing Then
Me.UsedRange.Interior.Color = xlNone
Application.Intersect(Target.Cells(1, 1).EntireRow, Me.UsedRange).Interior.Color = RGB(255, 255, 0)
End If
If Not Application.Intersect(Target.Cells(1, 1), Range("Colora")) Is Nothing Then
tVal = Target.Cells(1, 1)
Warr = Range("C11:G200").Value
For i = 1 To UBound(Warr)
For j = 1 To UBound(Warr, 2)
If Warr(i, j) = tVal Then
StRange = StRange & "," & Range("C11").Cells(i, j).Address
End If
Next j
Next i
If Len(StRange) > 3 Then
Me.Range(Mid(StRange, 2)).Interior.Color = Range("H1").Interior.Color
End If
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Warr, StRange As String, tVal
Dim i As Long, j As Long
'
Application.EnableEvents = False
If Not Application.Intersect(Target.Cells(1, 1), Me.UsedRange) Is Nothing Then
Application.Intersect(Target.Cells(1, 1).EntireRow, Me.UsedRange).Select
' Me.UsedRange.Interior.Color = xlNone
' Application.Intersect(Target.Cells(1, 1).EntireRow, Me.UsedRange).Interior.Color = RGB(255, 255, 0)
End If
If Not Application.Intersect(Target.Cells(1, 1), Range("Colora")) Is Nothing Then
tVal = Target.Cells(1, 1)
Warr = Range("C11:G200").Value
For i = 1 To UBound(Warr)
For j = 1 To UBound(Warr, 2)
If Warr(i, j) = tVal Then
StRange = StRange & "," & Range("C11").Cells(i, j).Address
End If
Next j
Next i
If Len(StRange) > 3 Then
Me.Range(Mid(StRange, 2)).Interior.Color = Range("H1").Interior.Color
End If
End If
Application.EnableEvents = True
End Sub
Torna a Applicazioni Office Windows
Inserimento parziale valore cella in MessageBox Autore: Ricky0185 |
Forum: Applicazioni Office Windows Risposte: 6 |
Ordinare colonne sulla stessa riga se stesso contenuto Autore: Ricky0185 |
Forum: Applicazioni Office Windows Risposte: 10 |
Aggiornare cella con somma quando aggiungo nuova colonna Autore: marcopont |
Forum: Applicazioni Office Windows Risposte: 1 |
Aumenta altezza riga in base valore cella Autore: trittico69 |
Forum: Applicazioni Office Windows Risposte: 47 |
Importare immagini a seconda del testo in una cella Autore: Paolo67met |
Forum: Applicazioni Office Windows Risposte: 4 |
Visitano il forum: Nessuno e 23 ospiti