mistery when the code compare two same value!

User avatar
sal21
PlatinumLounger
Posts: 4362
Joined: 26 Apr 2010, 17:36

mistery when the code compare two same value!

Post by sal21 »

Base the image attached why the code not show the msgbbox???????????

note:
The two variable are dimensione Double
You do not have the required permissions to view the files attached to this post.
Top
User avatar
HansV
Administrator
Posts: 78545
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: mistery when the code compare two same value!

Post by HansV »

Perhaps there is a non-breaking space after one of the two values?
Best wishes,
Hans
Top
User avatar
Guessed
2StarLounger
Posts: 102
Joined: 04 Feb 2010, 22:44
Location: Melbourne Australia

Re: mistery when the code compare two same value!

Post by Guessed »

Prova:
TOT_DARE = CDbl(Trim(Mid(RIGA, 49,17)))
DARE = CDbl(DARE)
Andrew Lockton
Melbourne Australia
Top

Return to “VB/VBA/.Net/Office Scripting”