ActiveX

To provide column IDs

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Set the Col property to specify the column for which you are setting the ID.
3. Set the ColID property to specify the column ID.
4. If you need to return the column number associated with a column ID, use the GetColFromID method.