Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rich Text Box
Hi,
Anyone know what a 'Rich Text Box' is or how to use it? Would it, for example, let you display text in a text box (or equivalent) without a cursor and with a scroll bar ? Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rich Text Box
My main area of expertise is in the compiled version of Visual Basic and we
have access to the Rich TextBox from within that language. What I am not sure of is if the Rich TextBox I have access to was delivered with my copy of the compiled version of Visual Basic or whether it came with Windows and VB simply gives me access to it. The point I am trying to make is that I don't know if the Rich TextBox is universally available or not. With that said, I just tried adding it to a UserForm and was successful in doing so (although I did get a warning about it being an ActiveX control and that such a control could be dangerous). If you have the compiled version of VB installed, or if it turns out that it is delivered with Windows automatically, then you will be able to put it in the UserForm's toolbox by right-clicking the toolbox and selecting "Additional Controls" from the menu that pops up. The name of the control, if you have access to it, is called Microsoft Rich Textbox Control 6.0. Once you have done that, you can add as many of them to your UserForm(s) as you need. This link will give you an overview of what the Rich TextBox is... http://msdn2.microsoft.com/en-us/lib...84(VS.60).aspx This link will take you to the online help file for the Rich TextBox control... http://msdn2.microsoft.com/en-us/lib...53(VS.60).aspx Rick "kirkm" wrote in message Hi, Anyone know what a 'Rich Text Box' is or how to use it? Would it, for example, let you display text in a text box (or equivalent) without a cursor and with a scroll bar ? Thanks - Kirk |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rich Text Box
A Rich Text Box enables something akin to html text formatting. It's highly
effective but a bit tricky and there are potential security problems in later versions. From memory the cursor will flash in the box. Didn't the use of a Frame work for you as I suggested in your other recent post, it seemed to work fine for me. Regards, Peter T "kirkm" wrote in message ... Hi, Anyone know what a 'Rich Text Box' is or how to use it? Would it, for example, let you display text in a text box (or equivalent) without a cursor and with a scroll bar ? Thanks - Kirk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rich Text Box
A Rich Text Box enables something akin to html text formatting. It's highly
effective but a bit tricky and there are potential security problems in later versions. From memory the cursor will flash in the box. Didn't the use of a Frame work for you as I suggested in your other recent post, it seemed to work fine for me. Regards, Peter T "kirkm" wrote in message ... Hi, Anyone know what a 'Rich Text Box' is or how to use it? Would it, for example, let you display text in a text box (or equivalent) without a cursor and with a scroll bar ? Thanks - Kirk |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rich Text Box
To Peter & Rick,
Apologies, I someow missed both your answers to my last question about this and have only seen them now. Yes I tried Setting focus elswehere as Rick desribed and found the same problem. I'd prefer not to try the Rich Text Box route, if possible, as it sounds quite daunting. Peter, your Frame method may be the best solution especailly if it worked for you. I'm just about to give it a try. Will report back. Thanks - Kirk |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rich Text Box
On Sun, 9 Mar 2008 21:29:52 -0000, "Peter T" <peter_t@discussions
wrote: Hi Peter, Didn't the use of a Frame work for you as I suggested in your other recent post, it seemed to work fine for me. Wow, not only does it work but it's a breeze to program and does exactly what I was hoping for. I've been over 2 months looking for this.... I'm staggered it was achievable, let alone so easily. Isn't it bloody amazing what we don't know ? :) Many thanks - beers all 'round! Cheers - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rich text box in forms | Excel Discussion (Misc queries) | |||
Rich Text Boxes | Excel Worksheet Functions | |||
Microsoft Rich Text Box registration | Excel Discussion (Misc queries) | |||
Rich Text Box | Excel Programming | |||
Problem with Excel using a .Net rich text box | Excel Programming |