Forum Discussion
Excelworksprograms
May 30, 2022Copper Contributor
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...
- Jun 01, 2022
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)?
HansVogelaar
Jun 01, 2022MVP
A / as decimal separator? I've never seen that. Or are they entering a date?
Excelworksprograms
Jun 01, 2022Copper Contributor
Oh i should check the code again when i get home the textbox doesnt get filled by typing it is calculated by another code which is for sure a double value then i want to save that in a cell on sheet
- HansVogelaarJun 01, 2022MVP
See how it works, it's best to test with various settings.