font

I'm look for VBA code to change the font size in a cell based on the number of lines in another cell. I use the following formula to find out the number of lines in the other cell: =LEN(InfoEntry!$B$14)-LEN(SUBSTITUTE(InfoEntry!$B$14,CHAR(10),""))+1 If the result of this formula is "8" lines...

I have a macro that works on my pc perfectly. When I try to run on other users pc I get the same error. Section below in red font is my issue. When I have other users run I get a DEBUG error and the red font highlights in Yellow. (Sorry I couldn't figure out how to hightlight in this website to...

Hi, I'm trying to set up a macro (attached to a button) that will do two things when clicked: - change the print area - change the font color in certain cells to match their background color. I have the code for changing the print area, but don't know how to get the other part. Basically...

good day, I know I can do part via'record macro, but there is some code that I do not have any idea on 'how to'? Could some kind coder sort some vb so when any cell within the range A1- S1000 changes the VB will auto run to apply the following:- Font & size Range a1 – s 1000 Calibri Light,16...

I want to have the font color in one column be driven by the value in another cell. I want the cells in column a to change color based on what the value is in column B if column b cell b1 is "completed" then column a cell a1 font will be Green If column b cell b1 is "IP" then column a cell a1...

Hi, I have a range of cells that are fixed in size (the row height / column width cannot change). The text string that goes into each cell is variable and could have anywhere from 10 to 150 characters in it. The cells are currently set for wrapped text with a font size 14 which satisfies most of...

I have this code that manipulates the appearance of a label in my user form. With .Controls(hfg & "_en") .BorderColor = RGB(51, 204, 51) .BorderStyle = 1 .ForeColor = RGB(51, 204, 51) End With The RGB is a shade of green...

Dear Sir, How can I Update My sheet1 data to Sheet2 without overlaping my existing data of Sheet2 with same font and font size. I also want to clear all data of sheet1 after updaing to sheet2 Using VBA code. Thank You in Advance.

Hi All Is there a way to make a font disappear without making the font color the same as the cell color? Thanks

Hello , I want this code to load with the font "David Libre" and size "10". If that is possible I want someone fix that into it for me. Sub OpenNotepadWithTempFileWithClipboardContent() Dim rngData As Range Dim strData As String Dim strTempFile As String ' copy some range...

I have 2 sheets in my file. I want to copy the font color in Sheet (MonNTM) to Sheet (Mon). I have tried this code but nothing happens. Sub setColorCity() Worksheets("Mon").Range("b12:aa19").Font.Color = Worksheets("MonNTM").Range("b12:aa19").Font.Color End Sub I would appreciate any...

Hi All The font size in a drop down list changes to become unreadable when I choose to print preview. The result prints in the smaller size too. It is the same whatever pc or printer we use. There are posts about changing font size but, nothing I can see that describes this issue. Any...

Every year when I do my taxes, I take last years excel tax work sheet and copy it. Then I take all dollar values and change the font to red. This way I know they are last year values that havent yet been updated. When I type in the current values for this year, I want the font to be black...

Hi, I've got a combo box with 4 options that change the font color of a range of cells (to red, blue , green, or black) using conditional formatting. I want another option to add a yellow fill color to the same cells but I don't want the existing font color to change. In conditional formatting...

Hi, When I do a vlook up, is it possible to get the the "content"+format (color font) of retrieved data? Thanks, Edu

The font in the formula bar somehow changed to italic and also one size smaller when I press F2 and the font is also showing in grey colour. But this only happen in one of the excel file. When I opened other excel file, the formula bar works perfectly fine and the font size & colour remain...

Hello - I'm totally newbie on Excel VB. i just happened that i have the tool that we use and just editing the code on it. Now, I would like to ask on how can i change the font of my txtBox, if the value of my textBox is 90% or above it will turn it to green, while if 89% below the font would...

Hi all, I want to know how much cell have a blue Font color within the cells that have a green background (and so on, 5 background colors and 5 Font colors). Exemple: I have 20 cells that have a green background, from those cells how much have a blue Font? Here are my formulas: Background...

The symbol ∧ does not work with Times New Roman Font in MS Excel for Mac 2013. But it works in MS Word for Mac. The symbol's stats in other encoding formats can be found here: http://www.fileformat.info/info/unicode/char/22c0/index.htm I will never upgrade to MS Excel 2016 because it's junk...

Is it possible to specify a font and size and maybe color for only one line? 'sig ssig = vbLf _ & vbLf _ & vbLf _ & sname _ ' would like to specify font and size and color here only & vbLf _ & ttl _ & vbLf _ & " Division" _ & vbLf _ & "8120 Way" _ &...