Hello everybody
In the attachment I have userform that has Combox .. It displays all sheets in the workbook when pressing F1
I want to make this combobox searchable as I tested it and when typing the first letter it directly go to any sheet which starts with that letter.. I want to have the feature of autocomplete in the list of sheets
I just need to be able to type part of the name of the sheet I want to navigate..to find easily my destination sheet
If it is impossible to do that with combobox..What's the alternative solution?
Last edited by YasserKhalil; 12-16-2014 at 09:48 AM.
Hi Yasser,
If I get it correctly, your current problem now is that the combobox unable to choose for the people with the same first letter name, ex: for Amany, Asmaa, Ahmed, Amgad, if we press A, it directly collapse without give opportunity to choose another one.
Here is my try to solve it (I have upload the file too) :
Maybe this is what you expected.
Please Login or Register to view this content.
Regards
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thanks Mr. karedog for offering help
I feel relief to your reply..
But I need to be able type two or more letters as the initials of the sheet name .. I mean AutoComplete feature..
Is it possible or not ? If not can you apply this idea by any means any way ??
what about this version?Go To Sheet UserForm2.xls
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hi,
What do you think about Arkadi's code ? It looked that this is the one you need.
You can add this additional code to select the sheet :
RegardsPlease Login or Register to view this content.
Thank you very much for all these good solutions
Mr. karedog do you remember the file you attached in a nother thread (serchable combobox) I'd like to do such a combobox .. it's more flexible and practical
Hi,
Thank you again for the reputation points.
I've just modify some settings and code, probably this one is what you expected (I have attach the file for you to test).
Settings :
Code :Please Login or Register to view this content.
Please try it and tell me some other else requirements that you need.Please Login or Register to view this content.
Regards
Fantastic Mr. karedog
Thank you very much for this great help ..
You are welcome, and again, I thank you for so many reputation points that you gave me.
Regards
Mr. karedog
You deserve more than points .. Thanks for all your help in every thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks