When I select an option from a ComboBox on a UserForm, the text in the ComboBox remains highlighted and I have to click in the ComboBox to remove the Text Highlight.
Is there any way when making a selection from the ComboBox to have the selection NOT highlighted/selected.
Many thanks for any help...
Last edited by HangMan; 07-13-2011 at 12:53 PM.
Hello hangman,
The highlight function is by design and can not be changed. However, you can make the highlight to disappear in code by having another object take the focus after the selection is made or by adding the code to the ComboBox Click event.
.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
You could move the focus to a different control, assuming you have one. This will move it to the next control in the tab order.
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Leith/David
Perfect, both solutions work perfectly...
Many thanks to you both. Gratefully appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks