Edit the code for the FormatTable macro in the Visual Basic Editor. What should be done to modify the font size?

1) Change the Font Size property value in the code.
2) Add a new line of code to set the Font Size.
3) Remove the existing code for Font Size.
4) Replace the code for Font Size with a different code.

To modify font size in Visual Basic Editor, you can change the Font Size property value in the existing code or add a new line of code to set the Font Size. The other two options aren't usually necessary and might disrupt the code's overall functionality.

Explanation:

To modify the font size in the FormatTable macro in the Visual Basic Editor, you can use either the first or the second option. You can change the Font Size property value in the existing code by locating the line of code that pertains to font size and altering the numeric value assigned to it based on the font size you desire. Alternatively, if the current code does not have a specification for Font Size, you can opt to add a new line of code to set the Font Size such as ActiveCell.Font.Size = 14, where '14' can be replaced with your desired font size. While the third and fourth options may seem valid, in most cases they aren't necessary, and they can potentially disrupt the overall functionality of your code.

Learn more about Visual Basic Editor Font Size Modification here:

https://brainly.com/question/32561262

#SPJ11