View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hemant_india[_2_] Hemant_india[_2_] is offline
external usenet poster
 
Posts: 107
Default 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