I did all the search for multiple drop box or list box that can connect to other list boxes but no luck.
It's the same as when you surf with Internet Explorer, you can click "Views" in menu bar, list box appear and then choose "Encoding", another drop box appear, then when you choose "More", then another box appear.
Is it possible to have this sort of hierarchy list box in excel where drop box connect to another drop box?
Thank you
Last edited by unley; 04-30-2009 at 05:14 PM.
Hi,
maybe this link will help
thank you for such a quick replay but not quiet what I'm searching for.
I would like a list box that has all the words that each can point out to another list ( the same way as "Encoding" from "View" menu to point out to another list box like the menu of Internet Explorer that I explained).
here's a fairly simple way
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you royUK, that's more like it but how will I paste the chose text to cell?
I cannot remember of how to put in codes for "OK" & "Cancel" buttons on Userform (sorry) so that the chosen one can be paste onto the active cell.
Thank you
Can you post this in a regular file and not a zip file? I don't have winzip, but this is what I am looking to do as well...
You could simply use the ListBox2 Click event to post it or add a button
ActiveCell.Value=Me.ListBox2.Value
Thank you very much royUK for your time, much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
unley 
Register To Reply
Bookmarks