|
我光是说说也不行,下面的代码就是用变量来自定义按钮;
按钮的名称在数组arr中,如果是想用单元格来定义按钮,先把单元格的内容写入数组arr就成了:
arr = Array("按钮1", "按钮2", "按钮3", "按钮4", "按钮5", "按钮6")
hs = 1
For i = 0 To UBound(arr)
Rows(i + 1).RowHeight = 50
ActiveSheet.Buttons.Add(369, 37.5, 128.25, 63.75).Select
With Selection
.Top = Cells(i + 1, 3).Top + 5
.Left = Cells(i + 1, 3).Left + 5
.Height = Cells(i + 1, 3).Height - 10
.Width = 100
.Characters.Text = arr(i)
.OnAction = arr(i) & "_click"
End With
Next i
用的是表单按钮,如果想用active按钮,方法是相同的,代码会有细节差别。并不需要记忆,线录制一个宏你就知道如何修改细节了; |
|