have-a-go-green
New Member
Hi
I'm trying to create a user friendly sheet, that, amongst other things in other sheets, will have one shett with the purpose of providing a WebBrowser that I have set up to, browse from the same cell that returns the results of a data validation list of URL's. The problem for the user, would be, that the URL's aren't exactly "user" friendly, even if it does work well to provide the browser function. I'm now wondering if there is a way to add a friendly name to the beginning of the URL, do that when the user, is making the selection from the data validation list, it maintains, both, the visual userbility and the functionality of the URL. I appreciate that, when you read this, you may ask, why I'm not just combining the HYPERLINK function with the data validation, well, I can assure you, I've triedand failed many many times in recent weeks to make that work and I've basically give up on that option.
Thanks in advance for any assistance you can provide.
I'm trying to create a user friendly sheet, that, amongst other things in other sheets, will have one shett with the purpose of providing a WebBrowser that I have set up to, browse from the same cell that returns the results of a data validation list of URL's. The problem for the user, would be, that the URL's aren't exactly "user" friendly, even if it does work well to provide the browser function. I'm now wondering if there is a way to add a friendly name to the beginning of the URL, do that when the user, is making the selection from the data validation list, it maintains, both, the visual userbility and the functionality of the URL. I appreciate that, when you read this, you may ask, why I'm not just combining the HYPERLINK function with the data validation, well, I can assure you, I've triedand failed many many times in recent weeks to make that work and I've basically give up on that option.
Thanks in advance for any assistance you can provide.