Problem with VBA Hyperlinks.Add taking Anchor from RefEdit in Userform

Right now there is a Runtime error - 13: Type mismatch

There is a solution that involves putting a Hyperlinks formula in the cell, but I would rather input the hyperlink itself, instead of a formula. I plan to export this Userform in another workbook, but I need it to work in the test workbook before I fiddle with the main workbook.

Any help with this problem would be greatly appreciated! Thank you Excel Community!

Hello Community,

I am still looking for a solution to this problem I am having. I am getting angry because nothing I do seems to help. I proceeded with adding a =HYPERLINKS formula into the cell itself instead of adding a hyperlink. I came across problems later in which I need to reference the hyperlink, and not a formula (which is my only current solution). I'm hoping that another set of eyes on this might bring some clarity as I've been staring at this trying to figure out why it is not working.

Sorry for the self-bump but I really need some input.

Thank you

After a lot of fiddling, I have finally found a solution to my problem. As it turns out, hyperlinks.add can be tempermental. I converted the output of the RefEdit control to R1C1 notation instead of A1 notation and that did the trick. Hopefully, this helps future users on their quest to solve their own riddles.

Thanks