[算表] VBA儲存格包含某字則跳出訊息
軟體:EXCEL
版本:2013
各位前輩高手好,
EXCEL VBA初學者希望能請教各路強者以下問題。
EXCEL示意圖如下:
A B C D
1 小君 小華
2 小安 小美
3 小明58 小和
我希望當偵測到儲存格A3包含"小明",
則啟動詢問視窗並提供是與否的選項,
當我選是則儲存格A3最後一碼數字"8"將覆蓋掉D3,
而儲存格A3倒數第二碼數字"5"覆蓋掉C3,
且回到A欄位中最後有文字的下一列(此例中為A4);
當我選否,則直接回到儲存格A1。
查詢後了解有if, msgbox,instr可以幫助解決,
但功力太淺希望能諮詢版上前輩,
還望能不吝賜教,謝謝!!
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 180.177.35.66
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1474909083.A.C95.html
→
09/27 07:18, , 1F
09/27 07:18, 1F
→
09/27 07:21, , 2F
09/27 07:21, 2F
→
09/27 07:24, , 3F
09/27 07:24, 3F
→
09/27 07:25, , 4F
09/27 07:25, 4F
→
09/27 07:27, , 5F
09/27 07:27, 5F
→
09/27 07:28, , 6F
09/27 07:28, 6F
→
09/27 07:30, , 7F
09/27 07:30, 7F
→
09/27 07:33, , 8F
09/27 07:33, 8F
→
09/27 09:46, , 9F
09/27 09:46, 9F
→
09/27 09:47, , 10F
09/27 09:47, 10F
→
09/27 09:48, , 11F
09/27 09:48, 11F
→
09/27 09:48, , 12F
09/27 09:48, 12F
→
09/27 09:48, , 13F
09/27 09:48, 13F
→
09/27 09:48, , 14F
09/27 09:48, 14F
推
09/27 09:53, , 15F
09/27 09:53, 15F
→
09/27 17:50, , 16F
09/27 17:50, 16F
→
09/29 20:36, , 17F
09/29 20:36, 17F
→
09/29 20:36, , 18F
09/29 20:36, 18F
→
09/29 20:39, , 19F
09/29 20:39, 19F
→
09/29 20:58, , 20F
09/29 20:58, 20F
→
09/29 20:59, , 21F
09/29 20:59, 21F
→
09/29 21:00, , 22F
09/29 21:00, 22F
→
09/29 21:01, , 23F
09/29 21:01, 23F
→
10/01 01:13, , 24F
10/01 01:13, 24F