Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

A simple ComboBox Question

Posted by Stan on October 19, 2001 10:29 AM

Acutally two questions:

1. When I put the control on a UserForm, the "arrow" for the dropdown does not show. What's up?
2. Is there a way to not have an item in the ComboBox highlighed after it is selected? As it stands, I have to click elsewhere on the form to remove the highlighting.

Stan

Re: A simple ComboBox Question

Posted by Juan Pablo on October 19, 2001 11:09 AM

1. I would check the ShowDropButtonWhen property and make sure it's either on WhenAlways or WhenFocus.

2. Use the ComboBox_Change() and put something like ActiveCell.Activate at the end of the procedure.

Juan Pablo

Re: Your Second Point

Posted by Stan on October 19, 2001 11:23 AM

Juan

I follow what you're saying but I don't have an active cell. I have a userform with a MultiPage control with command buttons. The cells of the worksheet are not active. Is there a way I can get the focus onto a command button so the ComboBox loses its highlighting?

Thanks

Stan

Re: Your Second Point

Posted by Juan Pablo on October 19, 2001 11:28 AM

Sure, if your button is named CommandButton1 put

CommandButton1.SetFocus

Juan Pablo

Thanks - that's the command I was looking for.

Posted by Stan on October 19, 2001 11:40 AM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.