| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
User Form Text Boxes - Copy format of text boxes
I have a user form that has five textboxes I have set it up so that if the
data entered meets certain criteria the colour of the entered data goes red using Rider2.ForeColor = vbRed What happens in the form is on enter the data is moved from Textbox2 to textbox3 using Rider3.Text = Rider2.Text How can I set this up so that the forecolour gets transfered with the contents. Just had a thought Rider3.Forecolour = Rider2.forecolour Would this work Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
User Form Text Boxes - Copy format of text boxes
What happened when you tried it?
NDBC wrote: I have a user form that has five textboxes I have set it up so that if the data entered meets certain criteria the colour of the entered data goes red using Rider2.ForeColor = vbRed What happens in the form is on enter the data is moved from Textbox2 to textbox3 using Rider3.Text = Rider2.Text How can I set this up so that the forecolour gets transfered with the contents. Just had a thought Rider3.Forecolour = Rider2.forecolour Would this work Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
User Form Text Boxes - Copy format of text boxes
Maybe nothing good happened... at least not with the "u" in there (or does
the British version of Excel use British spelling for its control properties). -- Rick (MVP - Excel) "Dave Peterson" wrote in message ... What happened when you tried it? NDBC wrote: I have a user form that has five textboxes I have set it up so that if the data entered meets certain criteria the colour of the entered data goes red using Rider2.ForeColor = vbRed What happens in the form is on enter the data is moved from Textbox2 to textbox3 using Rider3.Text = Rider2.Text How can I set this up so that the forecolour gets transfered with the contents. Just had a thought Rider3.Forecolour = Rider2.forecolour Would this work Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
User Form Text Boxes - Copy format of text boxes
Rider3.Forecolor = Rider2.forecolor works. Give myself a tick
"Rick Rothstein" wrote: Maybe nothing good happened... at least not with the "u" in there (or does the British version of Excel use British spelling for its control properties). -- Rick (MVP - Excel) "Dave Peterson" wrote in message ... What happened when you tried it? NDBC wrote: I have a user form that has five textboxes I have set it up so that if the data entered meets certain criteria the colour of the entered data goes red using Rider2.ForeColor = vbRed What happens in the form is on enter the data is moved from Textbox2 to textbox3 using Rider3.Text = Rider2.Text How can I set this up so that the forecolour gets transfered with the contents. Just had a thought Rider3.Forecolour = Rider2.forecolour Would this work Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text boxes retaining their last value on form close and restart | Excel Discussion (Misc queries) | |||
| copy check boxes (made from form toolbar) | Excel Discussion (Misc queries) | |||
| How do I preserve text boxes in a chart during copy/paste? | Charts and Charting in Excel | |||
| Form Text Boxes moving | Excel Worksheet Functions | |||
| How do I copy an Excel chart with added text boxes into Word or P. | Charts and Charting in Excel | |||
Linear Mode
