PC Review


Reply
Thread Tools Rate Thread

Combobox drop down

 
 
=?Utf-8?B?Ti5G?=
Guest
Posts: n/a
 
      14th Jun 2007
Hello,

I have a combobox that I generated through the toolbox. My code looks as such:

Private Sub ComboBox1_Change()
With Me.ComboBox1.TopLeftCell
..Offset(0, 5) = "NI"
..Offset(0, 6) = "UT"
..Offset(0, 7) = "ZAT"
..Offset(0, 8) = "ZB"
..Offset(0, 9) = "ZA"
..Offset(0, 10) = "Z1A"

The name of the combobox is "General" anytime I drop down this combobox to
make an item selection ( which produces the list above), the list desired
does come up, however I want to make it so that whenever Im done looking at
the generated list, I can go to the combobox and be able to select the
original title of the combobox; "General" and eliminate/delete my list.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
ComboBox does not drop down. Frank Martin Microsoft Access Forms 1 4th May 2010 05:57 AM
Combobox drop down =?Utf-8?B?Ti5G?= Microsoft Excel Misc 2 12th Jun 2007 10:09 PM
Combobox Drop down Niklas Östergren Microsoft Access Form Coding 3 8th Dec 2004 02:41 AM
drop down combobox alexanderd Microsoft Excel Misc 0 9th Jun 2004 09:26 PM
Drag&Drop in drop-down portion of a combobox MikeS Microsoft Dot NET Framework Forms 0 29th Dec 2003 10:33 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:43 AM.