Hi
When I try to use the code below the backcolor of the textbox does not change until the workbook is saved. I want the textbox to change colour when the save button has been hit on the userform. I would then have another set of code to change the colour back to its original colour once the workbook has been saved. I can't get any colours to change until the macro finishes running. Is this a timing problem?
Thanks in advance.
Private Sub CommandButton1_Click() UserForm1.TextBox1.BackColor = vbRed Workbooks("testbook").save 'here I change the textbox backcolor to black again UserForm1.TextBox1.BackColor = vbblack End Sub
Bookmarks