| 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 |
| 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 | |||
Threaded Mode
