fontcolor

  1. J

    Macro to run when cell on other sheet changes

    I am trying to make it so when a cell value is changed, all the sheets reset their color to black, then any changes made after that use a red font. I am pretty clueless at VBA, but have gotten the code below to work. It only works for my sheet1. Basically I want the font on all the sheets to...
  2. Jaafar Tribak

    Changing the Font & Back Colors of individual Tabs\Pages in a MultiPage

    Hi dear forum, As you know, the MsForms Multipage control doesn't offer a built-in functionality for changing the colors of individual tabs. I have seen many requests for this functionality over the years and the usual workaround has always been to add some helper buttons\labels , to change the...
  3. P

    VBA Worksheet Combobox Font color setting

    I have the following code which programmatically adds a combobox to a worksheet. Set Cell = WSD.Range("J2") WSD.OLEObjects.Add(ClassType:="Forms.ComboBox.1", link:=False, _ DisplayAsIcon:=False, Left:=Cell.Left - 5, Top:=Cell.Top + 3, Width:=Cell.Width + 125...
  4. A

    Can't drag down/right to automatically populate cells? Excel for Mac 15.32

    Hi all, Suddenly today, the little cursor to drag down to fill has "stopped working". I have a VBA-defined Name which is called by "FontColor" in my function as in the picture (I had to block out sensitive info). The code for FontColor in my defined name is: GET.CELL(24,Sheet1!X3:X252). The...
  5. C

    Can I automatically change the font color of a text in textbox without using VBA?

    I'm just a newbie in excel and I also don't have enough knowledge in programming. So we are tasked to make a program that should be flexible so we have to make 2 combo box the first combo box theres a number 1-10 on second combo box theres a number 1-12 for our program to be flexible, there must...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top