網頁 VBA 輸入金額： textbox 輸入金額：<input type="text" id="a"> button <input type="button" value="別懷疑按下去" onclick="alert('super')"> pig dog cat 複選radio pig<input type="radio">dog<input type="radio">cat<input type="複選radio"> pig dog cat 單選raido pig<input type="radio" name="pet">dog<input type="radio" name="pet">cat<input type="radio" name="pet"> hello world EXCEL VBA Private Sub CommandButton1_Click() Dim addnew As Range '定義 變數 addnew 是工作表的一個範圍 If Range("A1").CurrentRegion.Rows.Count = 1 Then> Set addnew = Sheets("DataTable").Range("A1").Offset(1, 0) Else Set addnew = Sheets("DataTable").Range("A1").End(xlDown).Offset(1, 0) End If addnew.Offset(0, 0).Va...
好 https://www.facebook.com/robertjcliu/posts/3976749985669533
回覆刪除