Im trying to get the text box to go red if the value is over 318 and green if under.
This code works if I put the value directly into the code.
Private Sub TextBox24_Change()
If Textbox3.Text = "Cathode Mother Roll" And TextBox24.Value > "318" Then TextBox24.BackColor = RGB(255, 0, 0)...
Please can someone help me?
I would like to get the second to last value in column C. I have this code so far but it just gets the last value.
TextBox3.Text = Range("C" & Rows.Count).End(xlUp).Text
Any help would be appreciated.
I'm hoping this is simple. I have a userform that I want to copy data from to two worksheets.
The first worksheet if fixes, the second worksheet is chosen from a userform list box selection. The listbox is populated with the names of the worksheets automatically so I know the sheet...