combobox problem

R

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
+-------------------------------------------------------------------
 
P

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top