View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Please help Please help is offline
external usenet poster
 
Posts: 75
Default How can I list values in a combo box?

Hello all,

I have a sheet with student information. Of the student information, Column
B is Student No. How can I have the student numbers listed in my combo box
of my user form.

I tried having "B:B" in the RowSource event of combo box, and I saw the
student numbers in the design mode. When I ran the user form, I didn't see
anything.

Then I tried having "B" in the ControlSource event and "B:B" in the
RowSource event of combox box, and, again, I saw them in the design mode.
When I ran the user form, I got an error "Path/file access error". The rest
of events was unchanged.

Please help.

Thanks.