Where do the header columns come from in a form?
 

Help!! Driving me crazy. Bit new to forms and the like, trying to
reverse engineer a bit of VBA. There's a form called
frmFaxRoomingLists. When I click on it the ListView is just a blank
white box but when it opens there are column headers (hotel,
telephone, fax number etc) and for the life of me I can't work out how
these headers appear. I've stepped through the code that displays it
and I can't see anything there, and I can't see anything in the
properties. But they must come from somewhere. Help!!

Where do the header columns come from in a form?
 

It is probably added either by the RowSource property of the form or by the
add.list or add.item methods in the initialize event of the UserForm. To
check for the RowSource property, open the VBE by pressing Alt + F11. In if
the form does not appear in the code windo then find it in the Project window
on the left and click it to display it. Then click the control on the form
that displays the list. The properties window should be displayed at the
lower left where you can scroll to find Row Source which will give you the
location of the items that show when the form is loaded. If there is no
entry in the Row Source line then double click the form and it should display
the code module where you can look for the UserForm_Initialize macro. It
should then identify how the items are added.

"ajnmx" wrote:

Help!! Driving me crazy. Bit new to forms and the like, trying to
reverse engineer a bit of VBA. There's a form called
frmFaxRoomingLists. When I click on it the ListView is just a blank
white box but when it opens there are column headers (hotel,
telephone, fax number etc) and for the life of me I can't work out how
these headers appear. I've stepped through the code that displays it
and I can't see anything there, and I can't see anything in the
properties. But they must come from somewhere. Help!!