gibt es eine Möglichkeit einen bestimmten Zellbereich in einem Label oder ähnliches in einem Userfom anzuzeigen.
z.B. a1:g5
Danke.
Ciao Dome
Private Sub Label1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Label1.Caption = Selection.Address
End Sub
Private Sub Label1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Dim zelle As Range
Label1.Caption = ""
For Each zelle In Range("A1:g5")
Label1.Caption = Label1.Caption & zelle.Value & Chr(13)
Next
End Sub