Type mismatch (Error 13)

[helplessnoobatexcel]

Hi All, I have this error in my code Type Mismatch (Error 13) that I am unable to rectify. Any idea on how I can do so? Btw I moused over the error during debugging and found my UserRow to be "".

 

[Georgiboy]

Is the value that is in cell B12 a number?

Note:

Dim UserRow, SheetCol as Long

Will only define SheetCol with a type, UserRow is left with no type
Try:

Dim UserRow as Long, SheetCol as Long

 

[helplessnoobatexcel]

Is the value that is in cell B12 a number?

Note:

Dim UserRow, SheetCol as Long

Will only define SheetCol with a type, UserRow is left with no type
Try:

Dim UserRow as Long, SheetCol as Long

Hi George, yep the value in cell B12 is a number.
I've tried your proposed solution and it gives me another problem which has the same error type of mismatch (error 13). Is there any possible underlying problems in this code? Thanks!

 

[Georgiboy]

What is the value you have in cell B12?

I ask as the new error row would suggest that B12 is either not a number or contains a decimal place etc.

 

[helplessnoobatexcel]

What is the value you have in cell B12?

It is a numerical value that changes everytime the user keys in their name in the login form and is used to determine the row number in which the user name belongs to

 

[Georgiboy]

What is the code that puts the value into cell B12?

Is the cell B12 formatted as text?

What do you see when you hover over '.Range("B12").Value

The new error is suggesting that VBA does not see B12 as a number, it may have a space on the end for example.

 

[Trebor76]

I've tried your proposed solution and it gives me another problem which has the same error type of mismatch (error 13).

Make sure there are no errors like #N/A or #REF! in the cells as they will cause a Type Mismatch error when a variable is trying to be assigned to it.

 

[helplessnoobatexcel]

What is the code that puts the value into cell B12?

Is the cell B12 formatted as text?

What do you see when you hover over '.Range("B12").Value

The new error is suggesting that VBA does not see B12 as a number, it may have a space on the end for example.

This is the formula for cell B12

Nope, cell B12 is formatted as a number with no decimal places
I see .'Range("B12").Value = "". Does this mean that it isn't registering anything in my User Row?

 

[helplessnoobatexcel]

Make sure there are no errors like #N/A or #REF! in the cells as they will cause a Type Mismatch error when a variable is trying to be assigned to it.

Hi Trebor,
Thanks for your suggestion, nope I've checked, there isn't any errors such as #N/A or #REF! as of currently. Only #N/A will be displayed in another cell to indicate that the user has not keyed in a password

 

[Georgiboy]

This means that your formula is hitting the IFERROR part and returning ""

You need to look at why your match is not working. I guess that UserName is a named range, maybe it does not contain a match to B9.