selectionchanged event
 

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
--
hemu

selectionchanged event
 

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)

"Hemant_india" wrote in message
...
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
--
hemu

selectionchanged event
 

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

regards
FSt1

"Hemant_india" wrote:

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
--
hemu