Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

combobox problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rstevens5l - 22 Mar 2006 17:42 GMT
in the file attached below i am having a problem with one of th
comboboxes.  If you go into the spread sheet under advanced and unloc
all (password is gmsafety123) and look in the definitions workshee
under the column titled area.  Then go into the visual basic edito
under forms -> newrec, the combobox for area does not display all o
the selections listed in the definitions worksheet.  Hod do i get al
the items listed under area in definitions worksheet to display in thi
combobox

+-------------------------------------------------------------------
|Filename: 5th_Core_Element_v[1]._01__Pontiac_Metal_Center.zip      
|Download: http://www.excelforum.com/attachment.php?postid=4506     
+-------------------------------------------------------------------
Philip - 22 Mar 2006 18:02 GMT
In the properties of the combo-box there is one called 'RowSource' ...

check the range being used as the source for the list, it's probably not
correct.

HTH

Philip

> in the file attached below i am having a problem with one of the
> comboboxes.  If you go into the spread sheet under advanced and unlock
[quoted text clipped - 9 lines]
> |Download: http://www.excelforum.com/attachment.php?postid=4506     |
> +-------------------------------------------------------------------+
rstevens5l - 23 Mar 2006 09:30 GMT
I checked the row source property like you said.  All the rowsourc
entries for my other comboboxes contained the header row title for th
selections.  All the other boxes work fine except the one.  For tha
one I had to designate the cells instead of just the header row title.
wierd...  Any ideas why this happened
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.