Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove focus from selection in combo or list box 1

Status
Not open for further replies.

Numbers1

Technical User
Dec 27, 2003
34
US
I would like to take the focus off of a selection after choosing it in a drop down combo box. The combo box is bound to an Excel worksheet where it obtains the list of items to be displayed. After selecting an item from the list, it is in blue and can be edited. I would like to have the selection uneditable and not in focus after its selection.
I have a similar problem of removing focus after selection in a list box except the items in the list box are from an array and are not editable when selected. However the selected item still shows up as being highlighted.
Thanks for your help.
Numbers
 
ActiveSheet.range("A1").Select will remove focus from the controls. Don't know if it de-selects in the list box.

Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top