![]() I have experienced the same problem with a project - everything works fine in Excel 2007-10 - but one user has upgraded to 2013 andġ) i'm afraid i don't know the underlying problem. There is no consistency that I can see as to which boxes will be a problem when I open the workbook.ġ) Does anyone have any idea what the underlying issue is and if so how to fix it?Ģ) Is there a way to change the WordWrap property via VBA code? If so, I will put code in a Workbook_Open sub to loop through the text boxes and cycle the WordWrap on and off. Which text boxes are affected is completely random. If I go into the properties of each text box and cycle the WordWrap property to "False" and the back to "True" the problem resolves itself until I exit the workbook and then open it again. The easiest way out if you have the developer tab is to add an ActiveX textbox (you will not be able to use. ![]() This makes it impossible to actually edit text. However, if you type some text and then exit the text box, the text returns to normal size. In the Character code box, just type in 2714. The inserting process is similar to that above. ![]() The Segoe UI symbol also allows you to insert a tick mark without the need to change the default fonts in the cell. Now when users click in certain text boxes, the cursor to enter text becomes so small that the user doesn't think they are in the text box. Select standard font color Red Type A1 (Hello) Hit enter Select standard font color Green Type B1 (World) Hit enter Font Name The default font in Excel is Calibri. Likewise, you can use the Segoe UI symbol font to get tick marks in Excel. This form worked fine until we upgraded to Office 365. I have an Excel file used as a form that has a number of form controls in it (text boxes, combo boxes, etc.).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |