font change

  1. S

    Create a button that change font color

    Hello.. again, I was amassed of how fast the first problem was solved and thank you for that. I have another question? Is there a way to creat a button that when clicked changes the font of all my in table rows (except header of the table) to black color, but when clicked again my different...
  2. E

    VBA code change and recognize text

    Hi guys, i need some help with word VBA. I have text in a bullet point form on my word doc and i would like to have certain things be done, when i run a macro. I am fairly new to VBA, therefore struggling with the coding aspect. Here is the text in m word doc: Tsla is up by 23% as compared...
  3. V

    Having multiple colors in a textbox

    I am trying to use VBA to insert a yellow textbox that has Procedures, Tickmarks, and Conclusion on separate lines. I have been able to do so. Now I am trying get font to change after the headings. Below is the an example and code for trying to get the font unbolded and black after...
  4. S

    VBA to change font type based on cell text

    Hi, I have a spreadsheet that contains a questionnaire. The answers are in the form of a data validation drop down list which is either "P" or "O". The font is set as Wingdings 2 so that the P is a tick symbol and the O is an X symbol. There are 4 different sheets that have this drop down...
  5. Manolocs

    Upper Case, Sentence case Help

    Hello, I have on column A a big list of words, cells contain one, two or several words. What I need is: 1-If the cell contains only one word, make this word in UPPER Case 2-If the cell contains more than one word, make the cell in SENTENCE CASE. Is it possible? Thanks in advance :)
  6. B

    Changing fonts in all the worksheets for the last row

    Hello Experts, I want a macro wherein I need help with changing the font type of the last row for all the worksheets. I have more than 20 worksheets everytime and the number of worksheets keep on changing everytime i get the report. I want to change the font type from Helvetica to Arial...
  7. A

    Issue with Font Change

    I have a macro in place which sends out emails from Lotus notes. I want to change the font of the body from times new Roman to "Arial".Can you please guide me as to how to do that. The following is the piece of code. With NRTStyle .NotesFont = FONT_ROMAN .FontSize = 12...

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