font size

Hello i have a program to extract data from cell and print it to the outlook but the problem is ,in one particular cell i have changed the font color and size but its is getting printed into the outlook as it is in the cell, it just print the default font size and color ... is there any solution...

I have a Userform with numerous textboxes on it (all the same size). When I set the Font size (Calibri 9 Regular) on all of them some appear (and actually are) larger than others (wider and taller). This happens regardless of setting their fonts each individually or all as a group. The...

Hi, I've seen a lot threads on the internet which say use a combo box to help with font size if the text is too small in a normal data validation list. They all seem to point to the same thread on contextures.com but that doesn't explain how to set up a combo box for 2010 version of excel. I...

For Information Only I searched fruitlessly for help on working out how much text would fill a Caption on a Radio Button (or more precisely, would the intended text fit when populating the Radio Button via VBA). With the help of others Mr. Excel members, I offer the following VBA solution...

OK, I'm doing something stupid. User form has several elements including three text boxes. I paste data from Internet Explorer to the three boxes (Ctrl v). At some point, despite the original font size declaration at design time and again on text box change events, one of the text boxes...

I have Office 2013, and have an Excel inspection form our technicians are going to be filling out in the field on tablets. There is a section for Notes that they can enter free text, and I've used an ActiveX text box for that purpose. But if I set the property "Multiline" to true, the font...

Hi, I have 6 pivot charts within a document. I use a macro associated with a button to refresh the tables and therefore the data displayed on the charts. However, each time I refresh the data, the 'data label' font size also refreshes. What is particularly odd is that 5 of the charts are...

Excel help file | Flickr - Photo Sharing! How do i increase the font size of the filter drop down menu?

Since upgrading to Office 2010 I've had an awful time reading the VBA help pages. At first the font was comically tiny, and the font-size adjuster button no effect. On another forum I was told to install a special CSS file, contents below: div { font-family:font-family: Arial, Helvetica...

Hi, I wonder if it does only to me (using Excel 2007): I have e.g. three separate words in one Excel cell, cell being formatted to Arial size 10. I decide to strikethrough one of the three words, which is done, but at the same time the font size of striked-through word is suddenly 8.5 instead of...

Hi, So, I have a worksheet with two columns I have to work with. In the first column is a word, and in the second column is a number. I have to change the font size of the word to the number in the other column. I'm not finding anything close enough to edit to suit my needs. Any help you can...

I have several workbooks with ActiveX command buttons which call userforms. Recently the command buttons have started shrinking or growing with every activation. As well, the font is smashed into a small point in the middle of the button. I have changed properties, text size, font, deleted...

Hi All, I have some code to change the font size of a range of merged cells based on the length of text within the cells. The code works fine when the sheet is unprotected, however when I protect it the code fails with the message "Run-time error 1004 - Unable to set the Size property of the...

hi all... I have excel 2007 and changed my screen resolution to (bigger) to view the help files. unfortunately with the ‘search scope’ set to ‘developer reference’ the font is tiny but with the other ‘search scopes’ the font size is bigger than before. I have changed the ‘font size’ button...

I need to format the font of the title of the axis on a chart. I'm using the following code: with ActiveChart.Axes(xlCategory).AxisTitle .AutoScaleFont = True .Font.Name = "Verdana" .Font.FontStyle = "Negrito" .Font.Size = 7 end with When I'm debugging the program, everything...

I have some code that creates two groups of checkboxes on a radar chart (we call them "for tests" and "for series"). Can not figure out how to setup font.size for it. Tried to stick it in few spots - no luck. Attached is a sample couple of checkboxes created by this code (for tests) Any...

If this topic is covered by a previous thread ... please forgive and link me to the thread. I've been searching for code that can do the following ... After cell update If character count is 5 or less set font size equal to 12 If character count greater than 5 set font size equal to 10 I'm...