Love your tutorial videos on forms. I have most of my form working but would like a different font size on the data sheet than the form. The input data on my form is going to be printed out on a preprinted sheet that requires some very small fonts in some of the areas larger fonts in others. Can you help me with that?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Different Font Size
0
Answers
0
Selected Answer
Hi Mike, glad you like it!
You can control the size of the fonts for each cell, row, column, or worksheet separately. You just get it how you want before you lock the spreadsheet. You change the formatting by selecting the desired cells and changing their style from the Home tab.
The macro for the form only transfers values and not formatting, so you can use all of your regular formatting setup for the spreadsheet.