Thus, the following code (which would normally place the information at the left side of the header) has the exact same results as the previous code:Ī = "&C&BAmalgamated Widgets, Inc. Remember that the use of positioning command codes such as these overrides placement. Also, note the use of the &C command code. The second use of the command code is to turn the bold attribute off, so that the date does not end up being bold. Note the use of the &B command code to make the company name bold. Using the example pictured here, inside the listbox, the words Symbol and Name appear as title headings. If your RowSource points to a range of cells, the column headings in a multi-column listbox are taken from the cells immediately above the RowSource. You would use the following code:Ī = "&C&BAmalgamated Widgets, Inc.&B" I was looking at this problem just now and found this solution. When used with the command codes discussed in other issues of ExcelTips, this is very powerful, indeed.įor instance, let's say you wanted a centered header that included your company name on the first line with today's date on the second. You do this by simply including the code Chr(13) into the string you use to set the header or footer. Thus, you could have a two or three line header or footer, if desired. If you use a macro code to set your header or footer, you can designate more than one line for them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |