Thanks a lot combo - the Change event did the trick.
Thanks for everybody's help with this - I'm setting this up for a charity so you've all done your good deed for the day!!
Thanks for the input PHV - I thought you'd cracked it! However it still only works if MultiSelect on the ListBox is set to 0.
A chance for me to have a go with the debugger!
Thanks for your time & expertise ktwclark, that's certainly got me a lot further.
However, and this may be a step too far, I would ideally like the same thing to happen when the ListBox has its MultiSelect property set to 1 or 2. i.e. Is there a way of identifying that "Other" has been selected...
I'm just getting to grips with VBA and am trying to set up a User Form (I have been using John Walkenbach's Excel VBA for Dummies - highly recommend it for newbies)
It's a questionnaire. I have put the possible answers for one question in a ListBox. The last option in the ListBox is "Other"; if...
Aquias: Perhaps we could agree on calling it a victimless crime?
I wonder if Bcastner's travelling companion (see above) would have preferred to have, given the same revenue, 8 million users of his product or 100 million.
I'd have thought that for theft to have occurred someone has to have lost something. If I download software that I would never have otherwise bought because it's too expensive for me, nobody has lost anything. In fact although the publisher would never admit it, I guess he would prefer me to be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.