change font

  1. M

    change font to bold and size when transferring from userform to sheet

    Hi, I have a userform, i have it set up to tranfer details from the userform to a sheet within the same workbook. I was wondering how i would go about changing the font to bold and change the font size of Label1.caption once it is transferred to the sheet? Many thanks for your help, Mike...
  2. 4

    Search For and Change Font For Certain Words With VBA

    I'm trying to find a VBA code that will search a particular range, for example A1:D300 on Sheet 1, for the phrase "Discounts Applied" and will increase the font to 16 and bold it. That particular phrase will be the only phrase in the cell it is located in. If it doesn't find that exact phrase...
  3. T

    Help with Macro to Change Fonts

    I have a macro that goes through each sheet and changes the worksheet font and the font on any graphs to be Arial. I have data labels on a couple of the graphs and some of them are bolded, italicized, or a different color. When I run the macro, it loses any formatting I had. Does anyone know how...

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
Back
Top