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

張畢業證書寫林鄭

6月畢業不過11月行畢業典禮咁係寫689定777

777

張畢業證書寫林鄭

女媧補天

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

Po上黎望下

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

Po上黎望下

巴打請教下nothing is found 個part,

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

點解無野出既?

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

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" 囉

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

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

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

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

唔明

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

Po上黎望下

https://drive.google.com/open?id=0Bz51c3uTfT4hTmY2MWNlcDk0Ulk
睇p.7, 10-11就可以
有個表要用while loop 搵 某個input box同column 1有冇matches, 但點樣可以跟返position column搵

例如position column寫end就一定要input box 最後個個同column 1 match先算match

如果要最簡單唔用其他function 只用while loop
你咪define 個int, 同boolean

唔直接比vba code 你，費事你直抄

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

Po上黎望下

https://drive.google.com/open?id=0Bz51c3uTfT4hTmY2MWNlcDk0Ulk
睇p.7, 10-11就可以
有個表要用while loop 搵 某個input box同column 1有冇matches, 但點樣可以跟返position column搵

例如position column寫end就一定要input box 最後個個同column 1 match先算match

如果要最簡單唔用其他function 只用while loop
你咪define 個int, 同boolean

唔直接比vba code 你，費事你直抄

While 加多個constr 就係i < 你keyword 數目+1
LEFT() 果度加番個if clause 變做boolean type output
之後response 出果個Cell(i-1,"C") 就ok
i-1 係因為你found到之後都會加左1

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

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 =""

1022Q有冇巴打可以講下position個part應該點做 完全冇idea

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 = .....

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

屌 隔幾分鐘就stop working一次

潘俊耀 (POON Chun Yiu)
別名 Kyrie, Prince, Cr Ken, 王子
電話：6051 5103
Facebook：Kyrie Poon https://www.facebook.com/ken.cr.3
Instagram: kyriejai https://www.instagram.com/kyriejai/,
kyrie_poon https://www.instagram.com/kyrie_poon/
Snapchat: prince_poon

bye

潘俊耀 (POON Chun Yiu)
別名 Kyrie, Prince, Cr Ken, 王子
電話：6051 5103
Facebook：Kyrie Poon https://www.facebook.com/ken.cr.3
Instagram: kyriejai https://www.instagram.com/kyriejai/,
kyrie_poon https://www.instagram.com/kyrie_poon/
Snapchat: prince_poon

bye

咩事

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
<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應該點做?

最簡單咩都唔好諗
一開始你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

潘俊耀 (POON Chun Yiu)
別名 Kyrie, Prince, Cr Ken, 王子
電話：6051 5103
Facebook：Kyrie Poon https://www.facebook.com/ken.cr.3
Instagram: kyriejai https://www.instagram.com/kyriejai/,
kyrie_poon https://www.instagram.com/kyrie_poon/
Snapchat: prince_poon

bye