http://www.excelpx.com/dispbbs.asp?boardid=5&replyid=1456045&id=70765&page=1&skin=0&Star=1 这是个很好的录入功能。请问学生录入后,能在录入表中自动给新增加的学生画上边框吗?
这样? Private
Sub CommandButton1_Click() '导入 Dim x%, y% With Sheet2 x = .[A65536].End(xlUp).Row + 1 For y = 1 To 10 .Cells(x, y) = Me.Controls("Tet" & y).Text Next y .UsedRange.Borders.ColorIndex = 1 End
With Call CommandButton2_Click End
Sub
|