[HKUST] 科大討論區 - 炒左mid term 女友話要分手 (14)

最簡單咩都唔好諗
一開始你initialise 左 Response = "" 先
之後就做個find keyword, if found, Response = whatever
最後如果唔係你個表啲keyword, response 是咪仲會係 null?
咁你咪加句 if response = vbnullstring, response ="Please tell me more" 囉

if 用嚟match keywords in the table
唔係你個表嘅keywords用else
sor 1999

唔明

用if...else...
if 係比你match keyword
<em>eg. 表有A, response 會出B
我打A 佢出B為match到 </em>
else (keyword not found)
response = "Please tell me more"
<em>else =假若keyword唔係個表入面，執行...
eg table 有 A，respone B
我打C 嘅時候佢就會出"Please tell me more"
而keyword唔洗set =""</em>

但佢assignment powerpoint 又話要用If......Then
Response = .....

你咪if LEFT(User.Value, Keyword.Cell) > 0 then response = Cell(response 果格).Value

仲有最後清0應該點做?

清咩0？
利申：無讀過comp Q

個worksheet 有counter column count 住個keyword出企幾多次，點樣可以用open event workbook 清0(每次開excel都可以變番0咁)

唔明

用if...else...
if 係比你match keyword
<em>eg. 表有A, response 會出B
我打A 佢出B為match到 </em>
else (keyword not found)
response = "Please tell me more"
<em>else =假若keyword唔係個表入面，執行...
eg table 有 A，respone B
我打C 嘅時候佢就會出"Please tell me more"
而keyword唔洗set =""</em>

但佢assignment powerpoint 又話要用If......Then
Response = .....

你咪if LEFT(User.Value, Keyword.Cell) > 0 then response = Cell(response 果格).Value

仲有最後清0應該點做?

清咩0？
利申：無讀過comp Q

個worksheet 有counter column count 住個keyword出企幾多次，點樣可以用open event workbook 清0(每次開excel都可以變番0咁)

Sub Open_Workbook
入面加個for loop

Po上黎望下

巴打請教下nothing is found 個part,

If Keyword = "" Then
Response = "Please tell me more"

點解無野出既?

最簡單咩都唔好諗
一開始你initialise 左 Response = "" 先
之後就做個find keyword, if found, Response = whatever
最後如果唔係你個表啲keyword, response 是咪仲會係 null?
咁你咪加句 if response = vbnullstring, response ="Please tell me more" 囉

if 用嚟match keywords in the table
唔係你個表嘅keywords用else
sor 1999

唔明

用if...else...
if 係比你match keyword
eg. 表有A, response 會出B
我打A 佢出B為match到
else (keyword not found)
response = "Please tell me more"
else =假若keyword唔係個表入面，執行...
eg table 有 A，respone B
我打C 嘅時候佢就會出"Please tell me more"
而keyword唔洗set =""

但佢assignment powerpoint 又話要用If......Then
Response = .....

你咪if LEFT(User.Value, Keyword.Cell) > 0 then response = Cell(response 果格).Value

仲有最後清0應該點做?

咁樣有bug

唔明

用if...else...
if 係比你match keyword
<em>eg. 表有A, response 會出B
我打A 佢出B為match到 </em>
else (keyword not found)
response = "Please tell me more"
<em>else =假若keyword唔係個表入面，執行...
eg table 有 A，respone B
我打C 嘅時候佢就會出"Please tell me more"
而keyword唔洗set =""</em>

但佢assignment powerpoint 又話要用If......Then
Response = .....

你咪if LEFT(User.Value, Keyword.Cell) > 0 then response = Cell(response 果格).Value

仲有最後清0應該點做?

咁樣有bug

Done

compQ 啲assignment 愈來愈煩嘅

compQ 啲assignment 愈來愈煩嘅

成班走曬堂做deadline fighter

正呀 聽日返學

正呀 聽日返學

不了

正呀 聽日返學

不了

又要上huma

正呀 聽日返學

不了

又要上huma

930 labu

compQ 啲assignment 愈來愈煩嘅

成班走曬堂做deadline fighter

最抵死個個sem有啲唔同
抄都無得抄

( Show Blocked User - 潘俊耀 )

真係好煩 唔想知m記點餐歌個個人係點

又要返學屌你老母

又要返學屌你老母

走堂囉

( Show Blocked User - 潘俊耀 )

真係好煩 唔想知m記點餐歌個個人係點

其實咩黎?

( Show Blocked User - 潘俊耀 )

真係好煩 唔想知m記點餐歌個個人係點

其實咩黎?

https://youtu.be/gRB5WJKH-tE

( Show Blocked User - 潘俊耀 )

真係好煩 唔想知m記點餐歌個個人係點

其實咩黎?

[rl]https://youtu.be/gRB5WJKH-tE[/url]

貼kpop都好過貼呢d啦

( Show Blocked User - 潘俊耀 )

真係好煩 唔想知m記點餐歌個個人係點

其實咩黎?

[rl]https://youtu.be/gRB5WJKH-tE[/url]

貼kpop都好過貼呢d啦

見到條柒頭就唔開胃
kpop起馬有得睇囡囡

對唔住






睇翻我既相啦

對唔住






睇翻我既相啦

對唔住

[mg]https://img.eservice-hk.net/upload/2017/03/26/213133_68c6e8cc64a6f1c04af2d8d95b8a18d0.jpg[/img]
[mg]https://na.cx/i/0NV4JOZ.jpg[/img]
[mg]https://img.eservice-hk.net/upload/2017/03/26/213141_309842b4c9acd727f80c173575d65168.jpg[/img]
[mg]https://na.cx/i/9t490Q3.jpg[/img]

睇翻我既相啦

ching又有睇

對唔住

[mg]https://img.eservice-hk.net/upload/2017/03/26/213133_68c6e8cc64a6f1c04af2d8d95b8a18d0.jpg[/img]
[mg]https://na.cx/i/0NV4JOZ.jpg[/img]
[mg]https://img.eservice-hk.net/upload/2017/03/26/213141_309842b4c9acd727f80c173575d65168.jpg[/img]
[mg]https://na.cx/i/9t490Q3.jpg[/img]

睇翻我既相啦

ching又有睇

純粹係youtube見到會click入去only

但佢assignment powerpoint 又話要用If......Then
Response = .....

你咪if LEFT(User.Value, Keyword.Cell) > 0 then response = Cell(response 果格).Value

仲有最後清0應該點做?

咁樣有bug

Done

row = row + 1呢 冇左會瘋狂loop到hang
For應該唔得
因為marking 好陰 佢話會轉個table
新既content有14行或更多就pk

我兩樣野 冇row = row + 1錯過
一開頭用for 都錯過

不過依家講都冇用了

連for loop 同while loop 都唔識分 ?