带你入门VBA系列之：不懂的代码快点贴过来

兰色幻想

to水滴:你给的代码太长了吧,你挑不会的问吧

水滴

不是太长啊，才二十几行。

那给我解释一下这段吧

Sub kk()
    Dim i As Long, r As Long, r1 As Long, j As Integer, k As Integer, ra As Range, F As Object
    Set F = Application.WorksheetFunction
    With Sheets("评分标准")
        k = .Cells(2, 256).End(xlToLeft).Column
        r = .Cells(65536, 1).End(xlUp).Row
        r1 = Cells(65536, 1).End(xlUp).Row
        Range(Cells(2, 8), Cells(r1, 8)).ClearContents
        For i = 2 To r1
            t = Cells(i, 2) & Cells(i, 5)
            c = F.Match(t, .Range(.Cells(2, 1), .Cells(2, 256)), 0)
            t = Left(Cells(i, 6), Len(Cells(i, 6)) - 1)
            Do
                If t = CStr(.Cells(3, c)) Then
                    Exit Do
                End If

woaicomputer

我怎么发 不了新贴呀？急呀！！！

VB燕子

请教一下，我加入一个textbox 控件，让某单元格的值等于输进该控件里的数字……

其实就是想炫耀下自己会用VBA，做得好看点，请教下代码，以下是我自己恶补来的，但是不通过，有问题，请老师帮我看看问题在哪里，谢谢

Sub TextBox1_Change()
TextBox1.Text
If TextBox1.Text <> "" Then
Sheets("Detailed").Select
Range("B3").Select
ActiveCell.Value = TextBox1.Text

End If
End Sub

试试改为:
Sub TextBox1_Change()

Sheets("Detailed").Range("B3").Value=textbox1.Value

End Sub

 

[此贴子已经被清风_ll于2006-7-11 18:21:09编辑过]

adau

那给我解释一下这段吧

Sub 分类()
    Dim i, j, s, x, y, z As Integer
    For i = 1 To 58
        a = 0
        s = Worksheets.Count
        For j = 1 To s
            If Sheets("sheet1").Cells(7 + i, 7) = Sheets(j).Name Then
                a = 1
                Exit For
            End If
            If a <> 1 And Sheets("sheet1").Cells(7 + i, 7) <> Sheets(Worksheets.Count).Name Then
               
                Sheets("表式").Copy After:=Sheets(Worksheets.Count)
                Sheets(Worksheets.Count).Name = Sheets("sheet1").Cells(7 + i, 7)
               
                Sheets(Worksheets.Count).Cells(3, 3) = Sheets("sheet1").Cells(7 + i, 7)
               
                x = 1
                For y = 1 To 58
                    If Sheets("sheet1").Cells(7 + y, 7) = Sheets(Worksheets.Count).Cells(3, 3) Then
                        For z = 2 To 6
                            Sheets(Worksheets.Count).Cells(7 + x, z) = Sheets("sheet1").Cells(7 + y, z)
                        Next z
                        x = x + 1
                    End If
                Next y
               
                Exit For
           
            End If
        Next j
    Next i
End Sub

jingzhg

好贴，向大师们学习，致敬！

[em05]

lsc

能否讲解一下，下面这段代码:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
     i = 2
     Do
       If i <> Sh.Index Then Worksheets(i).Visible = False
     i = i + 1
   Loop Until i > Worksheets.Count
End Sub

snowrong

QUOTE:

以下是引用lsc在2006-7-13 13:22:20的发言：

能否讲解一下，下面这段代码:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
     i = 2
     Do
       If i <> Sh.Index Then Worksheets(i).Visible = False
     i = i + 1
   Loop Until i > Worksheets.Count
End Sub

工作表激活事件

i=2

循环

如果i <> 表的索引值, 则 该工作表隐藏

下一个

直到循环到最后一个工作表

snowrong

QUOTE:

以下是引用adau在2006-7-12 11:21:36的发言：

那给我解释一下这段吧

Sub 分类()
    Dim i, j, s, x, y, z As Integer
    For i = 1 To 58
        a = 0
        s = Worksheets.Count  '工作表的个数
        For j = 1 To s ' 从1开始一直循环到最后一个工作表
            If Sheets("sheet1").Cells(7 + i, 7) = Sheets(j).Name Then  '如果表1的第七列,第八行开始的值等于后面某一个表的名字则执行下一行
                a = 1
                Exit For  '退出循环
            End If
            If a <> 1 And Sheets("sheet1").Cells(7 + i, 7) <> Sheets(Worksheets.Count).Name Then
'如果a的值不等于1 并且 表1第七列第八行开始的值不等于最后一个工作表名则                
                Sheets("表式").Copy After:=Sheets(Worksheets.Count)  复制表"表式",并且放在最后一个位置
                Sheets(Worksheets.Count).Name = Sheets("sheet1").Cells(7 + i, 7)
                '新建立的表名为表1第七列第八行开始的值
                Sheets(Worksheets.Count).Cells(3, 3) = Sheets("sheet1").Cells(7 + i, 7)
                ' 新建立的表的Cells(3, 3) = Sheets("sheet1").Cells(7 + i, 7)
                x = 1
                For y = 1 To 58
                    If Sheets("sheet1").Cells(7 + y, 7) = Sheets(Worksheets.Count).Cells(3, 3) Then

'如果从sheet1的.Cells(7 + y, 7)开始,有一个单元格的值等于Sheets(Worksheets.Count).Cells(3, 3) ,则
                        For z = 2 To 6
                            Sheets(Worksheets.Count).Cells(7 + x, z) = Sheets("sheet1").Cells(7 + y, z)
                        Next z
                        x = x + 1

'把表1的值从第二列到第六列的值给新建立表的第八行第2至第六列
                    End If
                Next y
               
                Exit For
            退出循环
            End If
        Next j

    Next i
End Sub

这里a应该是一个指针,新建立表以后该指针就为1,再次循环该值为0,再从1到58行那边接着往下循环.

snowrong

QUOTE:

以下是引用fengyun1982在2006-7-5 15:07:43的发言：

Rn = Cells(65536, 1).End(xlUp).Row: Cn = 28

这段代码的大概意思我知道的，就是选定行的范围的吧，可是Cn = 28不知道什么意思，谢谢。。

Rn = Cells(65536, 1).End(xlUp).Row

Cn = 28

两行,RN的值为第一列最后一行的行数,cn给初值28