Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
* Hello! I want to create a editable textbox in a UserForm like a MS WORD tha the user can edit the text (font, color, size, align...). This tex will be show in a label or textbox in other UserForm in a programmabl time if no user interference. PS: this programmable time is already soon. Thanks! -- Tim Armstron ----------------------------------------------------------------------- Tim Armstrong's Profile: http://www.excelforum.com/member.php...fo&userid=3716 View this thread: http://www.excelforum.com/showthread.php?threadid=56879 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
"Tim Armstrong" wrote in message news:Tim.Armstrong.2c4w5g_1154893809.2638@excelfor um-nospam.com... * Hello! I want to create a editable textbox in a UserForm like a MS WORD that the user can edit the text (font, color, size, align...). This text will be show in a label or textbox in other UserForm in a programmable time if no user interference. 1) textboxes are editable by default, i.e. the text can be "edited" by the user 2) What you mean is "formatting". Here it's all or nothing: The user can change font, font-size, color etc. only for the whole textbox, not for parts of it. You will have to provide a user interface for making these changes. Joerg |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
Tim,
Use a Rich Text Box if you need different font/size etc in the single box. NickHK "Tim Armstrong" wrote in message news:Tim.Armstrong.2c4w5g_1154893809.2638@excelfor um-nospam.com... * Hello! I want to create a editable textbox in a UserForm like a MS WORD that the user can edit the text (font, color, size, align...). This text will be show in a label or textbox in other UserForm in a programmable time if no user interference. PS: this programmable time is already soon. Thanks! * -- Tim Armstrong ------------------------------------------------------------------------ Tim Armstrong's Profile: http://www.excelforum.com/member.php...o&userid=37161 View this thread: http://www.excelforum.com/showthread...hreadid=568794 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
* Thanks guys! But, how can I do this? -- Tim Armstron ----------------------------------------------------------------------- Tim Armstrong's Profile: http://www.excelforum.com/member.php...fo&userid=3716 View this thread: http://www.excelforum.com/showthread.php?threadid=56879 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
Tim,
In the VBA Toolbox you should have an icon with horizontal blue lines and an "A" in the bottom right hand corner. Add that control to your user form. NickHK "Tim Armstrong" wrote in message news:Tim.Armstrong.2c5g27_1154919610.9346@excelfor um-nospam.com... * Thanks guys! But, how can I do this? * -- Tim Armstrong ------------------------------------------------------------------------ Tim Armstrong's Profile: http://www.excelforum.com/member.php...o&userid=37161 View this thread: http://www.excelforum.com/showthread...hreadid=568794 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
* NickHK, Thanks for the help! Sorry, but I don't found this "tool". I´m using Excel 2000. :( * -- Tim Armstrong ------------------------------------------------------------------------ Tim Armstrong's Profile: http://www.excelforum.com/member.php...o&userid=37161 View this thread: http://www.excelforum.com/showthread...hreadid=568794 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
Tim,
If it is not visible (although I thought it was included by default), right click on the Toolbox and select "Additional Controls...". Scroll down the list to "Microsoft Rich Textbox control and check the box on the left. Now you will have this control in the toolbox. NickHK "Tim Armstrong" wrote in message news:Tim.Armstrong.2c5jj8_1154924111.7401@excelfor um-nospam.com... * NickHK, Thanks for the help! Sorry, but I don't found this "tool". I´m using Excel 2000. :( * -- Tim Armstrong ------------------------------------------------------------------------ Tim Armstrong's Profile: http://www.excelforum.com/member.php...o&userid=37161 View this thread: http://www.excelforum.com/showthread...hreadid=568794 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
"Tim Armstrong" wrote in message news:Tim.Armstrong.2c5g27_1154919610.9346@excelfor um-nospam.com... * Thanks guys! But, how can I do this? So am I. Excel doesn't provide a RichTextBox control. Joerg |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
Joerg,
Yes it does. See my previous post. NickHK "Joerg" wrote in message ... "Tim Armstrong" wrote in message news:Tim.Armstrong.2c5g27_1154919610.9346@excelfor um-nospam.com... * Thanks guys! But, how can I do this? So am I. Excel doesn't provide a RichTextBox control. Joerg |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create a editable textbox?
Well, there is a "Microsoft Rich Text Box Control 6.0 (SP4)" in the list,
but trying to put it on the sheet produces a "cannot insert object". If I try to add it to the toolbox of the Macro Editor, the icon appears, but when I try to put it onto a form I get "The subject is not trusted for the specified action". As far as I can see this control came with an external add-on and does not belong to the original Excel2003. Maybe you refer to a different control. What's its name? Joerg "NickHK" wrote in message ... Joerg, Yes it does. See my previous post. NickHK "Joerg" wrote in message ... "Tim Armstrong" wrote in message news:Tim.Armstrong.2c5g27_1154919610.9346@excelfor um-nospam.com... * Thanks guys! But, how can I do this? So am I. Excel doesn't provide a RichTextBox control. Joerg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a Textbox in a standalone Excel 2007 chart using mac | Charts and Charting in Excel | |||
show the input message of a data validation list on a textbox and set editable | Excel Discussion (Misc queries) | |||
un-editable | Excel Discussion (Misc queries) | |||
Create a mask inside a textbox | Excel Programming | |||
textbox.value doesn't create a number? | Excel Programming |