combobox problem

[rstevens5l]

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]

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]

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