Yet another userform combobox question

[teepee]

Hi

Can anyone tell me how, when I select an option in a drop down menu in a
userform combobox, I can code it to shrink back down again once the
selection is made.

At the moment it just hangs there like a lemon until I click on it again

 

[Guest]

wow,
you're just posting this all over the place. ever wonder why no one is
answering your post. very impolite.

 

[Guest]

It might be a good idea to avail yourself of the copius information available
in the VBA help files for ComboBox properties, such a Selected and ListIndex.
Many of the questions thay you have been posting are readily answered in
those files. I personally don't mind helping beginners to understand how the
code works, if I know for sure. But I have found the information in the help
files to be just as reliable as much of the information provided by this news
group.

 

[teepee]

wow,
you're just posting this all over the place. ever wonder why no one is
answering your post. very impolite.

No it previously appeared at the end of another thread (where no-one would
see it) because I foolishly gave it the same name as a previous query. So I
renamed it so it would appear in its own thread. Seemed like a reasonable
thing to do. Appearing twice isn't all over the place but I'm sorry if it
breached netiquette.

 

[teepee]

It might be a good idea to avail yourself of the copius information
available
in the VBA help files for ComboBox properties, such a Selected and
ListIndex.
Many of the questions thay you have been posting are readily answered in
those files. I personally don't mind helping beginners to understand how
the
code works, if I know for sure. But I have found the information in the
help
files to be just as reliable as much of the information provided by this
news
group.

That's a very polite way of saying RTFM I shall take your advice to
heart.