Hi I'm working in VBA and I need to try to get long names to fit in a textbox I cannot increase. Is there a way to get the font size to scale down when a name is found to be too long to fit in the textbox?

Change the font name to 'Garamond' and the size to 6. This is probably the best READABLE font with only 6 points font size. If the long name still does not fit, you will either have to word wrap the text, which will increase your textbox size in height. This I think is about the only solutions available for you at the moment.