robertgama
Board Regular
- Joined
- May 4, 2011
- Messages
- 189
After I process data, I'm putting links back to the original data so the user can fix the values if there were errors.
Here is the worksheet formula in column F and in this case row 6:
aaGetHyperlinkLocation is just a UDF to return a properly formatted location for the hyperlink function from a range.
I would like to be able to do the same with VBA, resulting in a hyperlink the the cells back to 'Clients!H2'. How would that be accomplished with VBA?
Thanks,
Rob.
Here is the worksheet formula in column F and in this case row 6:
Code:
=IF(E6="Requires Fix",HYPERLINK(aaGetHyperlinkLocation(Clients!H2),Clients!H2),"")
aaGetHyperlinkLocation is just a UDF to return a properly formatted location for the hyperlink function from a range.
I would like to be able to do the same with VBA, resulting in a hyperlink the the cells back to 'Clients!H2'. How would that be accomplished with VBA?
Thanks,
Rob.