G
Guest
Can a macro replace text in a text box? How?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Userform1.TextBox1.Text = "abc"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
B
BenT
Thanks Bob
I also want to change text size and Font. Can you help with a small example code.
Thanks very much.
Bent
Userform1.TextBox1.Text = "abc"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
I also want to change text size and Font. Can you help with a small example code.
Thanks very much.
Bent
Userform1.TextBox1.Text = "abc"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
B
Bob Phillips
With UserForm1.TextBox1
With .Font
.Name = "Arial"
.Size = 11
End With
.Text = "abc"
End With
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Thanks Bob
I also want to change text size and Font. Can you help with a small example code.
Thanks very much.
Bent
Userform1.TextBox1.Text = "abc"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
With .Font
.Name = "Arial"
.Size = 11
End With
.Text = "abc"
End With
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Thanks Bob
I also want to change text size and Font. Can you help with a small example code.
Thanks very much.
Bent
Userform1.TextBox1.Text = "abc"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
B
BenT
Bob
Thank you very much.
Bent
With UserForm1.TextBox1
With .Font
.Name = "Arial"
.Size = 11
End With
.Text = "abc"
End With
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Thanks Bob
I also want to change text size and Font. Can you help with a small example code.
Thanks very much.
Bent
Userform1.TextBox1.Text = "abc"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Thank you very much.
Bent
With UserForm1.TextBox1
With .Font
.Name = "Arial"
.Size = 11
End With
.Text = "abc"
End With
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Thanks Bob
I also want to change text size and Font. Can you help with a small example code.
Thanks very much.
Bent
Userform1.TextBox1.Text = "abc"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)