how to add url links to listbox using command button
Hello everyone, i have created a userform1 with a commandbutton 'Add New' and a blank listbox. Now when i click on the 'Add New' button, another userform2 is opened where i can enter the URL. Once i enter the URL and click on the 'save' button on the userform2, the URL will be saved in sheet1 and also displays in the Listbox in userform1. Hope this made sense. Can this be done?
thank you for your help
You could display the URL in the listbox but it wouldn't automatically be active, ie clicking it would do nothing.
What you could do is add code to the Click (or BeforeDoubleClick) of the listbox that uses FollowHyperlink to, well, follow the hyperlink the user has clicked.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks