LinkBack URL
About LinkBacks
Guest 
With a textbox (from the Drawing toolbar) on a Userform
can I allow the user to select some of their text and :
1. Change the Font
2. Change the Font size
3. Underline it
4. Italicise it
Regards.
With a textbox (from the Drawing toolbar) on a Userform
can I allow the user to select some of their text and :
1. Change the Font
2. Change the Font size
3. Underline it
4. Italicise it
Regards.
I'm not sure what you mean by a text box from the Drawing
toolbar. However, if you have a regular MSForms textbox on a user
form, you can change the Font property in a variety of ways,
e.g.,
Me.TextBox1.Font.Underline = True
Me.TextBox1.Font.Italic = True
Me.TextBox1.Font.Name = "Times New Roman"
Me.TextBox1.Font.Size = 16
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:uXgCy2JMFHA.2384@tk2msftngp13.phx.gbl...
> With a textbox (from the Drawing toolbar) on a Userform
> can I allow the user to select some of their text and :
>
> 1. Change the Font
> 2. Change the Font size
> 3. Underline it
> 4. Italicise it
>
> Regards.
>
Apologies, that is what I meant.
For further clarity..........can the user make these changes after the form
is displayed?
Or can/must I use an ActiveX control?
Regards and thanks
"Chip Pearson" <chip@cpearson.com> wrote in message
news:On5VL6JMFHA.3832@TK2MSFTNGP12.phx.gbl...
> I'm not sure what you mean by a text box from the Drawing toolbar.
> However, if you have a regular MSForms textbox on a user form, you can
> change the Font property in a variety of ways, e.g.,
>
> Me.TextBox1.Font.Underline = True
> Me.TextBox1.Font.Italic = True
> Me.TextBox1.Font.Name = "Times New Roman"
> Me.TextBox1.Font.Size = 16
>
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Stuart" <sgbooth@totalise.co.uk> wrote in message
> news:uXgCy2JMFHA.2384@tk2msftngp13.phx.gbl...
>> With a textbox (from the Drawing toolbar) on a Userform
>> can I allow the user to select some of their text and :
>>
>> 1. Change the Font
>> 2. Change the Font size
>> 3. Underline it
>> 4. Italicise it
>>
>> Regards.
>>
>
>
If you provide some control for notification.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:extNI%23JMFHA.2604@TK2MSFTNGP10.phx.gbl...
> Apologies, that is what I meant.
> For further clarity..........can the user make these changes after the
form
> is displayed?
>
> Or can/must I use an ActiveX control?
>
> Regards and thanks
>
> "Chip Pearson" <chip@cpearson.com> wrote in message
> news:On5VL6JMFHA.3832@TK2MSFTNGP12.phx.gbl...
> > I'm not sure what you mean by a text box from the Drawing toolbar.
> > However, if you have a regular MSForms textbox on a user form, you can
> > change the Font property in a variety of ways, e.g.,
> >
> > Me.TextBox1.Font.Underline = True
> > Me.TextBox1.Font.Italic = True
> > Me.TextBox1.Font.Name = "Times New Roman"
> > Me.TextBox1.Font.Size = 16
> >
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> > "Stuart" <sgbooth@totalise.co.uk> wrote in message
> > news:uXgCy2JMFHA.2384@tk2msftngp13.phx.gbl...
> >> With a textbox (from the Drawing toolbar) on a Userform
> >> can I allow the user to select some of their text and :
> >>
> >> 1. Change the Font
> >> 2. Change the Font size
> >> 3. Underline it
> >> 4. Italicise it
> >>
> >> Regards.
> >>
> >
> >
>
>
Just use the Textbox control from the Toolbox in the VBA editor.
The user can't change the properties of the text box directly.
You would have to provide command buttons that would make the
requested changes via code similar to what I posted earlier.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:extNI%23JMFHA.2604@TK2MSFTNGP10.phx.gbl...
> Apologies, that is what I meant.
> For further clarity..........can the user make these changes
> after the form is displayed?
>
> Or can/must I use an ActiveX control?
>
> Regards and thanks
>
> "Chip Pearson" <chip@cpearson.com> wrote in message
> news:On5VL6JMFHA.3832@TK2MSFTNGP12.phx.gbl...
>> I'm not sure what you mean by a text box from the Drawing
>> toolbar. However, if you have a regular MSForms textbox on a
>> user form, you can change the Font property in a variety of
>> ways, e.g.,
>>
>> Me.TextBox1.Font.Underline = True
>> Me.TextBox1.Font.Italic = True
>> Me.TextBox1.Font.Name = "Times New Roman"
>> Me.TextBox1.Font.Size = 16
>>
>>
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting, LLC
>> www.cpearson.com
>>
>>
>> "Stuart" <sgbooth@totalise.co.uk> wrote in message
>> news:uXgCy2JMFHA.2384@tk2msftngp13.phx.gbl...
>>> With a textbox (from the Drawing toolbar) on a Userform
>>> can I allow the user to select some of their text and :
>>>
>>> 1. Change the Font
>>> 2. Change the Font size
>>> 3. Underline it
>>> 4. Italicise it
>>>
>>> Regards.
>>>
>>
>>
>
>
Many thanks to you both.
Now I understand.
Regards.
"Chip Pearson" <chip@cpearson.com> wrote in message
news:uk6VRBKMFHA.3356@TK2MSFTNGP12.phx.gbl...
> Just use the Textbox control from the Toolbox in the VBA editor. The user
> can't change the properties of the text box directly. You would have to
> provide command buttons that would make the requested changes via code
> similar to what I posted earlier.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
> "Stuart" <sgbooth@totalise.co.uk> wrote in message
> news:extNI%23JMFHA.2604@TK2MSFTNGP10.phx.gbl...
>> Apologies, that is what I meant.
>> For further clarity..........can the user make these changes after the
>> form is displayed?
>>
>> Or can/must I use an ActiveX control?
>>
>> Regards and thanks
>>
>> "Chip Pearson" <chip@cpearson.com> wrote in message
>> news:On5VL6JMFHA.3832@TK2MSFTNGP12.phx.gbl...
>>> I'm not sure what you mean by a text box from the Drawing toolbar.
>>> However, if you have a regular MSForms textbox on a user form, you can
>>> change the Font property in a variety of ways, e.g.,
>>>
>>> Me.TextBox1.Font.Underline = True
>>> Me.TextBox1.Font.Italic = True
>>> Me.TextBox1.Font.Name = "Times New Roman"
>>> Me.TextBox1.Font.Size = 16
>>>
>>>
>>>
>>> --
>>> Cordially,
>>> Chip Pearson
>>> Microsoft MVP - Excel
>>> Pearson Software Consulting, LLC
>>> www.cpearson.com
>>>
>>>
>>> "Stuart" <sgbooth@totalise.co.uk> wrote in message
>>> news:uXgCy2JMFHA.2384@tk2msftngp13.phx.gbl...
>>>> With a textbox (from the Drawing toolbar) on a Userform
>>>> can I allow the user to select some of their text and :
>>>>
>>>> 1. Change the Font
>>>> 2. Change the Font size
>>>> 3. Underline it
>>>> 4. Italicise it
>>>>
>>>> Regards.
>>>>
>>>
>>>
>>
>>
>
>
Nope, I cannot make this work.
Provide a Control to change all the text in some way seems ok, but letting
user select/highlight some of the text and alter their selection....that I
cannot see.
Regards.
"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:ubgV1FKMFHA.2136@TK2MSFTNGP14.phx.gbl...
> Many thanks to you both.
> Now I understand.
>
> Regards.
>
> "Chip Pearson" <chip@cpearson.com> wrote in message
> news:uk6VRBKMFHA.3356@TK2MSFTNGP12.phx.gbl...
>> Just use the Textbox control from the Toolbox in the VBA editor. The user
>> can't change the properties of the text box directly. You would have to
>> provide command buttons that would make the requested changes via code
>> similar to what I posted earlier.
>>
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting, LLC
>> www.cpearson.com
>>
>> "Stuart" <sgbooth@totalise.co.uk> wrote in message
>> news:extNI%23JMFHA.2604@TK2MSFTNGP10.phx.gbl...
>>> Apologies, that is what I meant.
>>> For further clarity..........can the user make these changes after the
>>> form is displayed?
>>>
>>> Or can/must I use an ActiveX control?
>>>
>>> Regards and thanks
>>>
>>> "Chip Pearson" <chip@cpearson.com> wrote in message
>>> news:On5VL6JMFHA.3832@TK2MSFTNGP12.phx.gbl...
>>>> I'm not sure what you mean by a text box from the Drawing toolbar.
>>>> However, if you have a regular MSForms textbox on a user form, you can
>>>> change the Font property in a variety of ways, e.g.,
>>>>
>>>> Me.TextBox1.Font.Underline = True
>>>> Me.TextBox1.Font.Italic = True
>>>> Me.TextBox1.Font.Name = "Times New Roman"
>>>> Me.TextBox1.Font.Size = 16
>>>>
>>>>
>>>>
>>>> --
>>>> Cordially,
>>>> Chip Pearson
>>>> Microsoft MVP - Excel
>>>> Pearson Software Consulting, LLC
>>>> www.cpearson.com
>>>>
>>>>
>>>> "Stuart" <sgbooth@totalise.co.uk> wrote in message
>>>> news:uXgCy2JMFHA.2384@tk2msftngp13.phx.gbl...
>>>>> With a textbox (from the Drawing toolbar) on a Userform
>>>>> can I allow the user to select some of their text and :
>>>>>
>>>>> 1. Change the Font
>>>>> 2. Change the Font size
>>>>> 3. Underline it
>>>>> 4. Italicise it
>>>>>
>>>>> Regards.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks