How do i format a text box in excel user form

  • Thread starter Thread starter Martin SChukrazy
  • Start date Start date
M

Martin SChukrazy

Hi
I am looking for a way to format a text box in Excel user forms. Is
there any way to do this or do i have to use a formatted text box control
(seperate control )

Martin
 
Martin;

You can modify many f the textbox' properties by writing code in procedures,
but is this what you want ?
FI: you can set the with and hight and disable or enable it.

Could you specify your question a little bit more !!

Mark.
 
There is not formatted text box control in the msforms 2.0 set of controls.
You can use an event to change the appearance in the textbox.

as an example:
Textbox1.Text = format(Textbox1.Text,"#,##0.00")

Depends on how values get in your textbox.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Text Boxes within A User Form 3
Tab character in a Text Box 1
Force proper case on user form text box 7
Text boxes in forms 1
Active X text box using Excel 2003 2
Check box to change the format of a text box 5
User form Text Box & Combo Box. 5
date fields in excel user form 1

Back
Top