Linking Font Size Changes

[swordswinger710]

This probably sounds really weird, but does anyone know whether the size of the text in Cell A1 on Sheet 1 can be linked to the size of the text in Cell B2 on Sheet 2? Like, when I change the size of Cell A1's text, is there a way to have the size of Cell B2's text change as well? Any thoughts are appreciated. -Juda

[VBA Noob]

Try this event macro in sheet 2

Right click sheet 2 > view code > paste in the below.
When you activate sheet 2 is takes Sheet 1 Range A1 font size

Please Login or Register  to view this content.

VBA Noob

[swordswinger710]

Thanks, that works, but I need Cell B2 to display the the value of Cell A1 with its font size right after it's entered on Sheet 1. Is that an option?

[VBA Noob]

Just put

=Sheet1!A1

in sheet 2.

More efficent to have the font update once then everytime it's changed

VBA Noob

[swordswinger710]

Here's the whole picture. I attached a copy of my workbook. The first sheet is where my data goes. From there, it is linked to many other sheets. I need the font size to be linked as well as the data. What is the best thing to do? Thanks, Juda

[VBA Noob]

I still don't understand the need.

If I was you I would link the cells with the formula as suggested then use a macro to stop the user changing the font size in the first sheet and job done.

VBA Noob

[swordswinger710]

OK, I'll try to explain myself a little better. The Data Entry Sheet is where I enter my data. I already have these cells linked to the correct places on the other sheets. You will notice that I use merged cells of varying lengths to show the user entering data how many digits can be entered before exceeding the width of the linked cells on the other sheets.

The problem, however, arises when more digits than usual need to be entered, and in order for all the information to be displayed correctly, the font size needs to be changed right there on the Data Entry Sheet.

So, once the user is satisfied with the way the information is displayed on the Data Entry Sheet, he/she can simply go to any of the other sheets, and the size of the digits in the linked cells that were changed on the Data Entry Sheet are the same size here.

I hope I was clear enough - if you have any other questions I'll be happy to answer them. -Juda

[VBA Noob]

Merge cells and macro's rarely work well.

If you get the layout correct then you could take a look at format > cells > alignment tab > Shrink to fit

If you still need a macro post back

VBA Noob

[swordswinger710]

Hey! I had no idea that 'format > cells > alignment tab > Shrink to fit' existed! Here I thought I'd need some huge fancy macro. Wow. That's all I needed, thanks a million! -Juda

PS - Keep up the great work!