Saltar al contenido
PROGRAMAR EN VBA MACROS DE EXCEL

Hyperlink link hipertexto en label y textbox

(adsbygoogle = window.adsbygoogle || []).push({});

Domina Excel Hoy

Hoy muestro como asignar un hyperlink link o hipertexto en un label y textbox de un userform de VBA, anteriormente en otros post se trabajo con hyperlink como son: hyperlink o link a google map, como enviar desde Excel mail con un hyperlink, copiar un hyperlink, índice con hyperlink a hojas de un mismo libro, índice o hyperlink a hojas de otro libro, índice con hyperlink a hojas del mimo libro y en cada hoja al menú principal.

Si estás leyendo este post es, porque estás desarrollando un proyecto que incluye Macros en Excel; existen en internet un sin número de cursos que enseñan a programar en VBA, codificación necesaria para programar macros, de todos ellos te recomiendo unos de los mejores cursos on line que he visto en internet.

El ejemplo de macro que se presenta permite crear un hyperlink, link o hipertexto en un label y en un textbox activándose en este último con doble click; presionando el botón aparece un formulario con un link en un label y en un textbox, haciendo click en el label dirige a la página o dirección establecida en el hipervinculo; en el textbox funciona haciendo doble click en el textbox.
Es útil por ejemplo en un formulario que contenga los datos de un cliente, proveedor, compañía aseguradora, que haciendo clik en el label o textbox que contenga el dato direccionando a la página web.
Otra utilidad puede ser en un formulario que contenga el dato del domicilio de los clientes, proveedores, compañías aseguradoras y haciendo click en el link nos redirija a google maps.
Se me ocurre que también podría servir cuando se requiera tener un link a archivos escaneados de clientes, proveedores, compañías aseguradoras; tiene un sin numero de utilidad, dependiendo de cada uno adaptarlo a las necesidades particulares.
Descarga el ejemplo del link del final. Considera la posibilidad de Aportar a los fines de seguir manteniendo el sitio, descarga desde el link del final el ejemplo; suscribe al blog para recibir en tu correo todas las actualizaciones, dispones también de un canal de You Tube donde encontrarás explicaciones de macros con mayor detalle.
Suscribe a nuestro canal de You Tube para recibir en tu correo vídeos explicativos sobre macros interesantes, como  por ejemplo formulario que crea un listado de todas las hojas para poder luego seleccionarlas, buscar en listbox mientras escribes en textbox, ordenar hojas libro excel por su nombre, conectar Excel con Access y muchos ejemplos más.

Código que se inserta en un módulo


Private Sub CommandButton1_Click()
Unload Me
End Sub
Private Sub Label1_Click()
ActiveWorkbook.FollowHyperlink «http://www.programarexcel.com»
End Sub

Private Sub TextBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
ActiveWorkbook.FollowHyperlink «» & TextBox1 & «»
End Sub

Private Sub UserForm_Activate()
Me.TextBox1 = «http://www.programarexcel.com»
End Sub

Si te fue de utilidad puedes INVITARME UN CAFÉ y de esta manera ayudar a seguir manteniendo la página, CLICK para descargar en ejemplo en forma gratuita.


(adsbygoogle = window.adsbygoogle || []).push({});

If this post was helpful INVITE ME A COFFEE and so help keep up the page, CLICK to download free example.

Si te gustó por favor compártelo con tus amigos
If you liked please share it with your friends      

Entradas relacionadas

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Comentarios (5)

You’ll get more results in less time. Try it for yourself — I guarantee you and
your woman will enjoy the results of Taoist Thrusting.

That will begin to shatter the destructive behavior.

Whether you guys see a marriage counselor at the time or begin dating again, make sure you
guys keep in contact with each other to cultivate your marriage.
Only this time I got more sucked in than ever. If you have children, staying under the same
roof with your spouse can do more hurt than good. There are steps you can take, with or without the aid of your spouse to get your marriage
back into the loving place it once was. There’s nothing
wrong with being stimulated outside your relationship, if you bring
that sexual energy back into the relationship with your partner.
But at the start of their relationship, the «love drugs»
make each want it as much as the other, with the partner with the lower sex drive experiencing an increase-again because of PEA.

Responder

Sure enough, we slept together twice, but when I tried
the third time he said he didn’t feel right because
he was straight and he blamed it on the alcohol (even though he told me it was the best sex
he ever had) We never hung out again. Please feel free to add them through comments.
You can just plug in your webcam and you can enjoy free live chatting.
No one else can do that for you. Most times in my life I have lived in apartments, but the one time my family had a
house during my teenage years, I adored it.
Just saying there is much more for you to experience in your
life if you want it. Most the time I think it is healthy so
I do not get too far out there and conform to a «normal»
that makes sense. I said yes why don’t you go run a
bath and shave your legs And when you get out
I will help you put some on.

Responder

Yeah last year during finals week I was watching a movie and there was a couple behind me and the guy was laying in the girls lap while she pet his head that was in 7th grade and they had
totally boned. Also my dad was having sex at 12 sooooooo

Responder

The young hardly find anyone to trust and confess their
situation to. The relief center extended its hotline services to 24 hours a day in July of last year following a shocking series of sexual assaults
against young teenage girls were revealed. Last summer, the public was shocked to learn about
a middle school girl who began to go into labor at her classroom
and later delivered a baby in an ambulance while being rushed
to the hospital. Those who sought help at the agency related to sexual molestation grew from 40 percent in 1995 to 48.5 percent last year of all the sexual violence cases handled
by the agency. The ‘related links’ section at the bottom of this article will help you locate further information on the NGS and their
open gardens. I know he is hurt and angry but I
dont know how to help him. I also would like to know that why the Jains were split into Digamber and Shwetamber.

Like the Rock Band guy, iNTERESTEDparty wasn’t interested in sex.

Responder

Hello! I’m at work browsing your blog from my new
iphone 4! Just wanted to say I love reading through
your blog and look forward to all your posts! Keep up the excellent work!

Responder