LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 293
Default Set Focus On ComboBox

Greetings,

I have a Toolbox ComboBox on a sheet. I need to clear its' contents
and then start typing into it to find the next match.

I tried this code to clear the contents:
__________________________________________________ ________

Private Sub ComboBox1_GotFocus()

ComboBox1.Text = vbNullString

End Sub
__________________________________________________ ________

This cleared the contents fine, but then jumped to the next cell in
the worksheet.

Is there a way to clear the contents of the ComboBox and stay in the
ComboBox until I'm finished finding the next record?

Any help will be appreciated.

-Minitman

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Canīt set focus on OleObjects ComboBox RCL Excel Programming 1 November 25th 06 02:49 PM
Which combobox has the focus? Daniel Bonallack Excel Programming 5 June 1st 06 02:20 AM
Focus after combobox Ed Excel Programming 4 September 27th 05 01:48 PM
ComboBox and Set Focus Ming Shao[_2_] Excel Programming 1 April 28th 04 06:55 PM
Focus on combobox atkscott Excel Programming 4 November 20th 03 12:36 AM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Đ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"