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

"rstevens5l" wrote:


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
all (password is gmsafety123) and look in the definitions worksheet
under the column titled area. Then go into the visual basic editor
under forms - newrec, the combobox for area does not display all of
the selections listed in the definitions worksheet. Hod do i get all
the items listed under area in definitions worksheet to display in this
combobox?


+-------------------------------------------------------------------+
|Filename: 5th_Core_Element_v[1]._01__Pontiac_Metal_Center.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4506 |
+-------------------------------------------------------------------+

--
rstevens5l
------------------------------------------------------------------------
rstevens5l's Profile: http://www.excelforum.com/member.php...fo&userid=5728
View this thread: http://www.excelforum.com/showthread...hreadid=525341