hyperlink in a textbox

[grkchakri]

Hi All

Can we insert hyperlink in to a textbox . My text box is on a sheet.

Example text1box.value = "https://google.com"

is there a code on the lines of follow hyperlinks.

Many thanx

[JBeaucaire]

Don't use a textbox on the sheet, use a cell, and in the cell use the HYPERLINK() function to create a clickable link.

Assume your textbox1 value is actually coming from a cell, say A1, then in B1 for example this would give you a clickable link:

=HYPERLINK(A1, "Click me")