I have Visual Basic for Apps program in Excel that obtains the coordinates of a point from TC, enters it in an Excel spreadsheet and then labels the point in TC. Everything works fine except the text settings. I've discovered that the text added to TC is controlled by the current settings of the Lines tool including layer, color, etc. However, since some text settings cannot be set in Lines, I always get Times New Roman as the font, for example. Can anybody tell me how to change the text settings?
"Nothing ever comes to one, that is worth having, except as a result of hard work."
--Booker T. Washington,
American educator and political leader