selectionchanged event

[Guest]

hi guys
i have a following code
dim t_string as string
t_string= target.value
target.clearcontents
target.value=iif(isnumeric(t_string(t_string),cdbl(t_string)/100000,t_string)
i am doing this to avoid circular reference
but i am getting error "type mismatch"
please help

 

[Bob Phillips]

What do you think/want this line to do

target.value=iif(isnumeric(t_string(t_string),cdbl(t_string)/100000,t_string)


in words defining the problem.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

hi,
strings are not numeric. declare T_string a long or appropreate.

regards
FSt1