Can't get combobox to display 2 columns.

[Paul]

I have the following in row source property :
=OFFSET(HLT51607!$a$2,0,0,COUNTA(HLT51607!$a:$a)-1,1)

this range is also called student_id_no

My problem is that I would like to also display Student name. this is not
happening

I have selected 2 for columncount but it still only lists one. The second
column range name is called student_name.

Firstly how do I fix my problem
also is there a better way to enter the rowsource details... perhaps by
using the named range instead of $a3$?

 

[RyanH]

Put this as the ColumnWidth Property: 25 pt;20 pt, (Column1;Column2). You
will have to adjust it to your application.

 

[Paul]

Sorry Ryan tried this and it still does not work