| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text Boxes and macros
Can a macro replace text in a text box? How?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Text Boxes and macros
Userform1.TextBox1.Text = "abc"
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bent" wrote in message ... Can a macro replace text in a text box? How? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Text Boxes and macros
Thanks Bob
I also want to change text size and Font. Can you help with a small example code. Thanks very much. Bent "Bob Phillips" wrote in message ... Userform1.TextBox1.Text = "abc" -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bent" wrote in message ... Can a macro replace text in a text box? How? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Text Boxes and macros
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) "BenT" wrote in message ... Thanks Bob I also want to change text size and Font. Can you help with a small example code. Thanks very much. Bent "Bob Phillips" wrote in message ... Userform1.TextBox1.Text = "abc" -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bent" wrote in message ... Can a macro replace text in a text box? How? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Text Boxes and macros
Bob
Thank you very much. Bent "Bob Phillips" wrote in message ... 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) "BenT" wrote in message ... Thanks Bob I also want to change text size and Font. Can you help with a small example code. Thanks very much. Bent "Bob Phillips" wrote in message ... Userform1.TextBox1.Text = "abc" -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bent" wrote in message ... Can a macro replace text in a text box? How? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
| Help with combo boxes and macros in Excel 2003 | Excel Discussion (Misc queries) | |||
| I need help with macros and check boxes. | New Users to Excel | |||
| In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions | |||
| Macros to delete check boxes | Excel Discussion (Misc queries) | |||
Linear Mode
