728x90

~t 앞에 아무 숫자를 넣어보세요. 정답인지는 모르겠네요.
//ls_t = "h1.background.color=~"553648127~tif(hoist"+string(k)+"=1,rgb(192,192,192),rgb(255,255,255))~""

> limit2님이 2007-08-08 오후 12:02:53에 남기신 글입니다.
> string ls_crop_nm, mod_string, err
> long color1, color2, color3, default_color
>
> color1 = 255 //red
> color2 = 16711680 //blue
> color3 = 65280 //green
> default_color = 16777215//white
>
> mod_string = "crop_cd.Background.Color = '~tIf("+ ls_crop_nm + "= '06'," + String(color2) + "," + String(default_color) + ")'"
>
> err = This.Modify(mod_string)
>
> IF err <> "" THEN
> MessageBox("Status", "Change to Background Mode Failed " + err)
> RETURN
> END IF

출처 : http://www.pbdn.net/board/BoardShow.aspx?board_id=2&role=qna&page=7&c_id=10330&c_seq=2&sfield=subject&svalue=%c6%af%c1%a4

 

여러 셀 바꾸고 싶을 경우 case when then 으로 처리
tmp2 = "'"+dw_5.object.compute_0006[i]+"' then rgb(255,0,0) "
"compute_0006.background.color=~"553648127~tcase(compute_0006 when "+tmp2+" else rgb(255,255,255))~""

728x90

+ Recent posts