VBA第六课 循环判断数据

Sub do_loop循环判断()Dim cj%cj = 1Docj = cj + 1If cj > 10 ThenExit Do'退出循环ElseIf Cells(cj, 2) >= 90 Then Cells(cj, 3) = "优秀"If Cells(cj, 2) >= 80 And Cells(cj, 2) <= 90 Then Cells(cj, 3) = "良好"If Cells(cj, 2) >= 60 And Cells(cj, 2) <= 80 Then Cells(cj, 3) = "合格"If Cells(cj, 2) < 60 Then Cells(cj, 3) = "不及格"End IfLoopEnd Sub

转载请注明作者与出处:王小涛_同學

,发光并非太阳的专利,你也可以发光

VBA第六课 循环判断数据

相关文章:

你感兴趣的文章:

标签云: