LinkBack URL
About LinkBacks
I want to select single items in list box available to move to specific worksheet. Is it possible? can any one help?
I want to select single items in list box available to move to specific worksheet. Is it possible? can any one help?
This is not mine, but it might give you a start.
HTH
Regards, Jeff
Thanks for your reply. Your attachment will help me other way round. Basically what I want is that I should select an item in list box which will help me go to sheet as per requirement. It will be like hyperlink. My attachment will make it more clear.
Last edited by sumonrezadu; 04-24-2012 at 09:27 PM. Reason: Forgot to attach sheet
The example I attached or here are the best options.
After much searching, I can't find a way to do it through a list box not attached to a user form.
Sorry
Yes I also searched for last 2 days but found no appropriate solution. I am sure someone will solve this problem. Because in last 2 years always find my answer in this useful forum.
Thx
would a simple hyperlink not work better for you?
...insert hyperlink...place in document...select sheet to jump to...
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
But how can I set hyperlink in listbox item? I don't want simple hyperlink. I want to select item in listbox which will force to go to desired sheet. See my attached sheet, you will better understand.
i did see your attached file. im suggesting that you use the hyperlink instead of the listbox
When my purpose is to click List Box item to go to desired sheet why I try other than list box? A problem can be solved by many alternative way you know. I need solution for list box because it will look smarter.
Put this macro in a standard code module
Assign the macro to the listbox.
Please Login or Register to view this content.
You will need to add any other items you want the listbox to deal with
Yesssssss. Perfect! That's what I wanted. Thank you so much. My problem is solved.
Hi Andy,
I hope everything is great for you. I need your urgent help please.
I created a listbox on a worksheet. I would like to go to specific worksheet which I linked, when I select an item from the listbox and click a button that I created on the same ws. I've found this macro from you wrote but it doesnt inlude the button code. Please help me. Thank you in advance.
Best Regards,
Please Login or Register to view this content.
Last edited by arlu1201; 05-14-2013 at 06:19 AM.
aydinaks,
Welcome to the forum - 2 pointers -
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.
Also, you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
arlu1201,
I understand your comments and sorry for my unexperienced behaviour. Thank you.
Just in case you wanted specific text. I did the following:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks