Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print one header over several columns of data | Excel Discussion (Misc queries) | |||
Header Columns | Excel Discussion (Misc queries) | |||
How do I create and name header rows and columns? | New Users to Excel | |||
Referrencing columns by header and from different worksheets | Excel Programming | |||
Can I have a user form with no Header/Caption Bar ? | Excel Programming |