Code to Select a Combobox with having to Manually Mouse or Tab to enter a value

's Computer Specifications

How can i Code, to SELECT a Combobox, so the User does not have to manually
Mouse and Click or TAB to it?

Corey....

's Computer Specifications

Corey,
On a WS you can:
Worksheets(1).ComboBox1.Activate
or
Worksheets(1).ComboBox1.DropDown

The second method will leave the drop down showing until the combox is
clicked though.

On a form:
ComboBox1.SetFocus
or
ComboBox1.DropDown

NickHK

"Coza" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How can i Code, to SELECT a Combobox, so the User does not have to
manually
> Mouse and Click or TAB to it?
>
> Corey....
>
>

's Computer Specifications

Thanks Nick.
SetFocus was the one i needed.

Cheers

Corey....
"NickHK" <(E-Mail Removed)> wrote in message
news:uG$(E-Mail Removed)...
> Corey,
> On a WS you can:
> Worksheets(1).ComboBox1.Activate
> or
> Worksheets(1).ComboBox1.DropDown
>
> The second method will leave the drop down showing until the combox is
> clicked though.
>
> On a form:
> ComboBox1.SetFocus
> or
> ComboBox1.DropDown
>
> NickHK
>
> "Coza" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> How can i Code, to SELECT a Combobox, so the User does not have to
> manually
>> Mouse and Click or TAB to it?
>>
>> Corey....
>>
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I select a range manually with the mouse?	ian	Microsoft Excel Programming	10	31st Oct 2007 12:31 AM
Combobox: On enter select entire value	Rasmus	Microsoft Access Forms	3	3rd May 2004 12:58 AM
Unable to select text in a Combobox with a mouse	=?Utf-8?B?QmFkQmFydA==?=	Microsoft Dot NET Framework Forms	0	17th Feb 2004 09:56 PM
ComboBox Code for Mouse and Keyboard	George Hartas	Microsoft C# .NET	0	23rd Jul 2003 07:33 PM
ComboBox Code for Mouse and Keyboard	George Hartas	Microsoft Dot NET Framework Forms	0	22nd Jul 2003 04:04 PM