VBA Combobox with hyperlink

Hi, before writing the post I searched around about my problem.

I have a combobox that allows me to select the exercises and insert them in the cell I want, everything works fine here.

The problem is that the source cell contains a hyperlink that is not included in the new cell.

Can someone help me ?

I attach the images and Code

HTML Code: 

VBA Combobox Hyperlink-min.jpg

more than likely you can't change this, because this is a consequence of how excel's source code is written. however, you can probably add some code to automate the addition of hyperlinks to the cells that you are populating from the dropdown. here's an example of how a column of data, which is originally text, can be turned into hyperlinks that have the same URL address as the actual text sitting in the cells:

Please Login or Register  to view this content.

Thanks for reply and time you are dedicating to me.
Unfortunately that's not what I was looking for, i would need to link directly to the names of the exercises. I found youtube.com/watch?v=Iylrxl4hW9M&feature=youtu.be&t=257 this video, explaining how to create a drop down menu with data validation. That's exactly what i was looking for, however, i was wondering if it was possible to add links in the dropdown menu.

Now, can this function be done via VBA combobox or data validation? It's a process that would speed up my work. The final product i want is a workout card with exercise names that are hyperlinked. Currently I have to take every single link from youtube and insert it manually in every single exercise. I thought I had a faster job with a dropdown containing hyperlinked exercise name.

Originally Posted by snake93x

Now, can this function be done via VBA combobox or data validation?

you know, I'm not really sure. I'm more of a coder and I don't generally do much through the interface, although I know how to do quite a bit. I cannot help anymore here. I apologize. Hopefully the pros here can help out.

Ohh! Thank you very much, you helped me a lot. That's what I was trying to do, now I can boost my work process.
Thanks again for answering my question.

Hi, here i am back to improve the functionality of the proposed code.

Only after having compiled a good list, I realized that when a link is not available, excel reports an error.

Do you think it is possible to fix this little bug?

Thanks, it works correctly.

Hi, come back for another short question.

I have been trying to fix a problem for 4 days, but have failed.

Basically I'm trying to have more columns available for the Dtatabase sheet.

So I changed .Columns (1) to Columns ("A: K"), this works, but some cells are ignored and others replaced.

Can you help me?

Thanks

Formula:

Please Login or Register  to view this content.

Thanks for the reply, I have attached the file containing the complete code.

At this point I assume that the problem is the second piece of code in .Range ("A2"). End (xlDown) .Row etc ...

In database sheet, cell A2 contains the squat exercise with link to the video. When in coaching sheet insert squat in the first line of training day 1, the link does not work, while the other exercises are ok.

-

Furthermore, is it possible to limit the comboboxes only to the coaching sheet? When I modify the database sheet by adding or deleting exercises, the combobox unintentionally adds me the previously selected exercise.

Thanks again for your reply. The code seems to work, however, when hit the category combobox, clicking on main lift, the exercises combobox shows me the categories again.

screen1.PNG

entered your code like this, right?

Please Login or Register  to view this content.

Thanks, the code is great and working fine. However, the problem of broken links persists.

If I choose to include the squat exercise, it contains a different link from the original. This only persists for cells A2 and A3 of the database, all other links work fine. I really have no idea what it might be.

I would be very grateful if you could help me with this last bug.

Thanks for your time and patience, I respect you very much.

Great, it's ok now, it's working fine. I will keep in mind your observation of exercises of the same name, I will adopt variations.

You were my hero for this project, thank you very much.
I am grateful to you for the time and patience you have given me.

Have a nice day, greetings.