MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing text in forms


Posted by David Williams on August 16, 2001 4:57 AM

How can the text properties (size, font etc) be changed in a form item ie. check box, label ?

Dave


Posted by M Walker on August 16, 2001 5:02 AM

Hi,

If you select the relavant label or check box and look at the properties you can edit it by double clikcing on font.

Hope that helps.

Matt

Posted by David Williams on August 16, 2001 5:55 AM

Hi Matt

When you say properties do you mean in format control. If yes then where is the "font" item. If no then which properties do you mean.

Thanks

Dave

Posted by M Walker on August 16, 2001 7:32 AM

Hi,

Sorry, i didn't make myself clear. Using the VBA edior right click on the relavant object - label etc. If you select "properties" from the menu you'll find the font property about a third of the way down. Double click on this and you'll be able to edit the font.

Hope this helps.


Matt

Posted by David Williams on August 16, 2001 12:17 PM

Hi and thanks again for your time

If I go into the VBA edior I can't find the relevant object. I have no macros working yet and things like the check box do not seem to be entities in their own right. I can get to properties for the sheet but that has no font entries.

Thanks again
Dave

Posted by Ian on August 16, 2001 4:03 PM


Hi what check boxes are you using??
it sounds like the ones from the Forms list the you can't (well you might be able to but I don't know) change the font easily

if this is the case use the Control Toolbox ones goto_View_Toolbars_Control Toolbox

if you use these then you can right click on the item and veiw the properties and veiw it VBE

hope this helps

Ian

Posted by David Williams on August 17, 2001 12:55 AM

Hi Ian

Thanks. I can now get the effects I wanted. Are there any disadvantages to using the Control Toolbox instead of the forms toolbox?

Dave

Posted by Ian on August 17, 2001 4:13 AM

there are far far more distinct advantages,
they work in completely different ways
I'm not good at VB stuff so what I suggest is you look at the properties list and play around with the different options.
One main diffence is that you don't get the link cell option in the format cells box.
it's on the properties thingy

Ian