[算表] VBA表單傳遞參數時ByRef引數型態不符

看板Office作者o1o3o1o31030 (主席)時間1年前 (2023/04/10 10:14)推噓1(1推 0噓 8→)

留言9則, 1人參與討論串1/2 (看更多)

軟體: Excel 版本: 365 用VBA製作了一個UserForm，用來鍵入參數鍵入後按確認傳遞給SUB 但是一直出現ByRef引數型態不符請版大救救我 ------------------------------------------------------ Private Sub BT1_Click() Dim P, S, D As Integer If CBB1 = "上" Then P = 1 ElseIf CBB1 = "下" Then P = 8 End If If CBB2 = "左" Then S = 1 ElseIf CBB2 = "右" Then S = 0 End If If CBB3 = "前" Then D = 1 ElseIf CBB3 = "後" Then D = 0 End If Call 測試(P, S, D) ------------------->這裡出現ByRef 引數型態不符 Unload UF1 End Sub ------------------------------------------------------- Public Sub 測試(P As Integer, S As Integer, D As Integer) msgbox P & S & D End Sub ----------------------------------------------------------- 謝謝各位 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 1.163.121.90 (臺灣) ※ 文章網址: https://www.ptt.cc/bbs/Office/M.1681092878.A.0B2.html

推

waiter337

04/10 10:40, 1年前 , 1^F

04/10 10:40, 1^F

→

waiter337

04/10 10:42, 1年前 , 2^F

04/10 10:42, 2^F

→

waiter337

04/10 15:37, 1年前 , 3^F

04/10 15:37, 3^F