Forum Discussion
Solved
Type missmatch
Hi ive run into trouble in a weired situation of type mismatch error There are two computers installed the same version and build and both 64 bit When the vba code runs in the first it doesnt retur...
See if it works if you use
Wsabc.Cells(1,2).Value = Val(txtabc.Text)
If not: do the users where it fails use a different decimal separator than you (point vs comma)?
Can you click Debug in the error message and find out which line causes the problem?
- I just found that a cells value is like this
Wsabc.cells(1,2).value=cdbl(txtabc) in which txtabc is on a user form the code runs by clicking a command button on the form
The problem is this code runs on my computer and some other but it gets to a type mismatch on another computer with same version and build of excelSee if it works if you use
Wsabc.Cells(1,2).Value = Val(txtabc.Text)
If not: do the users where it fails use a different decimal separator than you (point vs comma)?
- Oh thanks yes i think that user uses / instesd fo comma.does the val function gives a numerical value ?
