MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

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

Re: Your Second Point

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

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

Re: Your Second Point

Sure, if your button is named CommandButton1 put

CommandButton1.SetFocus

Juan Pablo

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

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