type 13 error

I am creating many userforms for a project and I want to have a common color theme. And I created a column that has all the colors I want to use. So instead of having to say Label1.ForeColor= RGB(0,0,0) in each userform, I want to be able to just reference that cell that has the color...

Hi all, i am writing the VBA that about change the cell (E19:E24) value if cell D18 value changed and change the cell D18 value if E19: E24 anyone cell value changed. When the value of D18 is "NA", the value of E19 to E24 is "NA". When the value of D18 is "C", the value of E19 to E24 is "C"...

Hi all I can't seem to figure out why I keep getting this error returned. I've tried all different variable types and nothing seems to work. Any help is appreciated. Private Sub TextBox2_Change() Dim Hrs As Variant Hrs = TextBox2.Value - TextBox1.Value TextBox6.Value = Hrs End Sub

Good day, Having trouble making a work project to work. Keep getting Error 13 Type mismatch for Application. Evaluate. If Application.Evaluate(FC.Formula1) Then ActiveCondition = Ndx FC.Formula1 = AND($C8<>"";ISBLANK($AI8)) If I change the conditional formating to a single logic test the...

Hello All, Here's what i'm trying to do: I have a userform which prompts the user to populate numbers when a drop-down value on column D is "Yes". And based on the entered number, current row will be replicated. However, I am running into Type Mismatch error 13 after the row is replicated...

Hi Everyone, Hope you're all in good form. I am stuck on this. I have a worksheet containing lots of columns 300+ and data. I am transforming this into a new worksheet with the columns re-arranged and some renamed etc. The VB code I have so far has worked to complete these tasks OK. However...

I am trying to do a dynamic "Hide Rows" function where if a certain cell in a row has any value a number "1" will populate the A cell of that row, an example would be if cell B11 has value A11 will be equal to "1"... What I had the macro doing was hiding all rows where A = "" The code had been...

Hello all, I'm very new to VBA... I understand that generally a type mismatch means you have a variable defined wrong. But I can't figure out what it is! There's an Excel sheet with a grades. Test 1, Test 2, Test 3, etc. I'm trying to calculate the final grade with specific curves with their...