ich habe in einem Feld Link: www Adresse - wie kann ich es machen - dass es ein Hyperlink zum Anklicken wird.?
Also alle Eingaben in dem Feld nur :)
https://ibb.co/B6LBRzG
lg:)
Sub hyperLink()
Dim Zelle As Range
Dim rngSpalte As Range
Set rngSpalte = Range("N2:N1000") 'die Spalte wo der Link sein soll anpassen!
For Each Zelle In rngSpalte
If Zelle = "" Then Exit For
ActiveSheet.Hyperlinks.Add Anchor:=Zelle, Address:=Zelle.Value
Next
End Sub
Gruß
'Hyperlink aktivieren für Z
Sub hyperLink()
Dim Zelle As Range
Dim rngSpalte As Range
Set rngSpalte = Range("L4:L10000") 'die Spalte wo der Link sein soll anpassen!
For Each Zelle In rngSpalte
If Zelle = "" Then Exit For
ActiveSheet.Hyperlinks.Add Anchor:=Zelle, Address:=Zelle.Value
Next
End Sub
aber nichts tut sich :( lg
Sub UserformBeenden () 'kann natürlich anders heißen das weist nur Du
Dim Zelle As Range
Dim rngSpalte As Range
Set rngSpalte = Range("L4:L10000") 'die Spalte wo der Link sein soll anpassen!
For Each Zelle In rngSpalte
If Zelle = "" Then Exit For
ActiveSheet.Hyperlinks.Add Anchor:=Zelle, Address:=Zelle.Value
Next
Dein Code
Unload Me
End Sub
Gruß
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, _
ByVal Y As Single)
If InStr(TextBox1.Value, "@") > 0 Then
ActiveWorkbook.FollowHyperlink "mailto:" & TextBox1
TextBox1.ForeColor = RGB(139, 35, 35)
End If
End Sub
Was macht diese Prozedur:
'Hyperlink aktivieren für Textbox
Private Sub TextBox13_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, _
ByVal Y As Single)
If InStr(TextBox1.Value, "@") > 0 Then
ActiveWorkbook.FollowHyperlink "mailto:" & TextBox1
TextBox1.ForeColor = RGB(139, 35, 35)
End If
End Sub
'Hyperlink aktivieren
Sub hyperLink()
Dim Zelle As Range
Dim rngSpalte As Range
Set rngSpalte = Range("L4:L10000") 'die Spalte wo der Link sein soll anpassen!
For Each Zelle In rngSpalte
If Zelle = "" Then Exit For
ActiveSheet.Hyperlinks.Add Anchor:=Zelle, Address:=Zelle.Value
Next
End Sub
das habe ich jetzt eingefügt
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, _
ByVal Y As Single)
If InStr(TextBox1.Value, "https://") > 0 Then
ActiveWorkbook.FollowHyperlink TextBox1
Else
ActiveWorkbook.FollowHyperlink "https://" & TextBox1
End If
TextBox1.ForeColor = RGB(139, 35, 35)
End Sub
Gruß Uwe
'Hyperlink aktivieren für Textbox
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, _
ByVal Y As Single)
If InStr(TextBox13.Value, "https://") > 0 Then
ActiveWorkbook.FollowHyperlink TextBox1
Else
ActiveWorkbook.FollowHyperlink "https://" & TextBox1
End If
TextBox1.ForeColor = RGB(139, 35, 35)
End Sub
'Hyperlink aktivieren
Sub hyperLink()
Dim Zelle As Range
Dim rngSpalte As Range
Set rngSpalte = Range("L4:L10000") 'die Spalte wo der Link sein soll anpassen!
For Each Zelle In rngSpalte
If Zelle = "" Then Exit For
ActiveSheet.Hyperlinks.Add Anchor:=Zelle, Address:=Zelle.Value
Next
End Sub
lg
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, _
ByVal Y As Single)
If InStr(TextBox13.Value, "https://") > 0 Then
ActiveWorkbook.FollowHyperlink TextBox1
Else
ActiveWorkbook.FollowHyperlink "https://" & TextBox1
End If
TextBox1.ForeColor = RGB(139, 35, 35)
'Hyperlink aktivieren
Dim Zelle As Range
Dim rngSpalte As Range
Set rngSpalte = Range("L4:L10000") 'die Spalte wo der Link sein soll anpassen!
For Each Zelle In rngSpalte
If Zelle = "" Then Exit For
ActiveSheet.Hyperlinks.Add Anchor:=Zelle, Address:=Zelle.Value
Next
End Sub
Gruß