[VBA ] 關於select case的問題
請問一下
假設我從excel裡面開啟VBA
然後製作了一個按鈕
假設A為textbox1 B為textbox2
請問如果我想要令 A=1 B=1~15 時 顯示出來的數字為X
A=1 B=16~30 時 顯示出來的數字為Y
要怎麼寫才會通呢?
不好意思新手入門
感謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 123.50.39.179
→
11/23 22:52, , 1F
11/23 22:52, 1F
→
11/23 23:24, , 2F
11/23 23:24, 2F
→
11/23 23:30, , 3F
11/23 23:30, 3F
→
11/24 10:13, , 4F
11/24 10:13, 4F
→
11/24 10:14, , 5F
11/24 10:14, 5F
→
11/24 10:20, , 6F
11/24 10:20, 6F
→
11/24 10:21, , 7F
11/24 10:21, 7F
推
11/24 11:51, , 8F
11/24 11:51, 8F
→
11/24 14:07, , 9F
11/24 14:07, 9F
→
11/24 14:08, , 10F
11/24 14:08, 10F
推
11/25 10:19, , 11F
11/25 10:19, 11F
→
11/25 11:54, , 12F
11/25 11:54, 12F
→
11/28 00:23, , 13F
11/28 00:23, 13F