LinkBack URL
About LinkBacks
Hi,
I want to select a sheet when userform initialized in the listbox items. The listbox works fine but i cannot figure out how to select on item when form load.
Hi,
I want to select a sheet when userform initialized in the listbox items. The listbox works fine but i cannot figure out how to select on item when form load.
Do you want this?
Please Login or Register to view this content.
What will be the criteria to select an certain sheet?
It will have to do with setting Listindex as hungt already showed but based on what?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yes, you are right, that's what i want. Changing the value can select any sheet.
Thank you.
OK but how are you going to tell the code which value to set? Does it change everytime you open the userform or will it always be a fixed item or .....
No, the code is related some other codes, so i can change it later from that code, initially i want select for the first sheet.
OK, then the code provided by hungt will do.
Good luck with your project and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks