|
发表于 2015-2-1 07:37
|
显示全部楼层
本楼为最佳答案
本帖最后由 adders 于 2015-1-31 18:44 编辑
Sub test()
Dim j As Integer, cel As Range
j = Cells(Rows.Count, "C").End(xlUp).Row
With ActiveSheet.Shapes("切换").DrawingObject
If .Caption = "全选" Then
For Each cel In Range("C2:C" & j)
cel.Value = cel.Value & "√"
cel.Characters(Len(cel), 1).Font.ColorIndex = 3
Next cel
.Caption = "反选"
Else
For Each cel In Range("C2:C" & j)
If Right(cel, 1) = "√" Then cel.Value = Left(cel.Value, Len(cel) - 1)
Next cel
.Caption = "全选"
End If
End With
End Sub
|
评分
-
查看全部评分
|