Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Avi Avi is offline
external usenet poster
 
Posts: 29
Default form combobox auto expand

hi, i have some comboxes on my form. I wanted that to expand
automatically, when it gets focus. Any help in this regard is
appreciated. Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 921
Default form combobox auto expand

Private Sub ComboBox1_Enter()
Me.ComboBox1.DropDown
End Sub


"Avi" wrote:

hi, i have some comboxes on my form. I wanted that to expand
automatically, when it gets focus. Any help in this regard is
appreciated. Thanks.
.

  #3   Report Post  
Posted to microsoft.public.excel.programming
Avi Avi is offline
external usenet poster
 
Posts: 29
Default form combobox auto expand

Thanks Jeff.

On Jan 26, 3:54*pm, Jeff wrote:
Private Sub ComboBox1_Enter()
* *Me.ComboBox1.DropDown
End Sub



"Avi" wrote:
hi, i have some comboxes on my form. I wanted that to expand
automatically, when it gets focus. Any help in this regard is
appreciated. Thanks.
.- Hide quoted text -


- Show quoted text -


Reply
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
Auto-expand/rich auto-complete option in Excel combo boxes Keith Howard Excel Programming 1 March 21st 09 04:16 PM
Combobox Events to Shrink and Expand Width RyanH Excel Programming 4 October 14th 08 02:48 PM
auto expand rows [email protected] Excel Worksheet Functions 3 December 14th 05 07:45 AM
auto expand rows [email protected] Excel Programming 3 December 14th 05 07:45 AM
Auto Expand Combo Box TimH[_2_] Excel Programming 1 November 6th 03 06:35 PM


All times are GMT +1. The time now is 05:56 PM.

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

About Us

"It's about Microsoft Excel"