- 日志
- 好友
- 卖家信用
![](static/image/traderank/seller/0.gif)
- 买家信用
![](static/image/traderank/seller/0.gif)
- 注册时间
- 2011-3-31
- 在线时间
- 小时
|
发表于 2011-12-15 23:30:10
|
显示全部楼层
- Private Sub CommandButton1_Click()
-
- 'copy sheet with the input name
- Sheets("original").Select
- Sheets("original").Copy After:=Sheets("original")
- ActiveSheet.Name = TextBox1.Text
-
- Dim i, j As Integer
-
- For i = 2 To Sheets("original").Cells.SpecialCells(xlLastCell).Row
- For j = 2 To Sheets("original").Cells.SpecialCells(xlLastCell).Column
- Select Case ComboBox1.Value
- Case "<"
- If CDbl(Sheets("remark").Cells(i, j)) < CDbl(TextBox2.Text) Then
- Sheets(TextBox1.Text).Cells(i, j) = Sheets("original").Cells(i, j)
- Else
- Sheets(TextBox1.Text).Cells(i, j) = 0
- End If
- Case "<="
- '.....
-
- End Select
- Next
- Next
- End Sub
- Private Sub UserForm_Initialize()
- ComboBox1.AddItem "<"
- ComboBox1.AddItem "<="
- ComboBox1.AddItem "="
- '......
- End Sub
复制代码 不多说,上代码。。。 |
评分
-
查看全部评分
|