Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click event on menu item is lost after first time firing of the event | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
How to trap delete row event and hide column event? | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |