24小时热门版块排行榜    

查看: 8041  |  回复: 5

gyh930912

铁虫 (小有名气)

[求助] 形成5*5的方阵,分别输出方阵中个元素,上三角和下三角元素的vb代码

各位高手,小弟急需这个代码,如有知道滴,谢谢分享!!!
回复此楼

» 本帖附件资源列表

  • 欢迎监督和反馈:小木虫仅提供交流平台,不对该内容负责。
    本内容由用户自主发布,如果其内容涉及到知识产权问题,其责任在于用户本人,如对版权有异议,请联系邮箱:xiaomuchong@tal.com
  • 附件 1 : IMG_20130520_094058.jpg
  • 2013-05-25 21:39:55, 811.08 K

» 猜你喜欢

已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖

魔血奋斗历史

银虫 (小有名气)

感谢参与,应助指数 +1
ben_ladeng: 应助指数-1, 非有效应助,收回应助指数。谢谢理解 2013-05-26 20:59:29
简单,你等一会,我给你编一个发过来
2楼2013-05-25 22:15:29
已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖

魔血奋斗历史

银虫 (小有名气)

不好意思,长时间不玩这个,忘了
3楼2013-05-25 22:23:45
已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖

ausir

木虫 (正式写手)

【答案】应助回帖

感谢参与,应助指数 +1
在 Excel 的VBA 工程中,添加用户模块,按以下方式运行:

Sub Matrix()
Dim theMat(0 To 5, 1 To 5) As Single

Dim s As String, s1 As String, s2 As String, s3 As String, s10 As String, s20 As String, s30 As String

Dim i As Integer, j As Integer

For i = 1 To 5
   For j = 1 To 5
       's = "请输入第" & CStr(i) & "行第" & CStr(j) & "列的数值"
       theMat(i, j) = (i - 1) * 5 + j 'Val(InputBox(s, "")
    Next j
Next i

'MsgBox ("输入完成,按确定后显示输入的阵列。"

s1 = ""
s2 = ""
s3 = ""
For i = 1 To 5
    s10 = ""
    s20 = ""
    s30 = ""
    For j = 1 To 5
        s10 = s10 & Format(theMat(i, j), "0000" & "   "
        If i <= j Then s20 = s20 & Format(theMat(i, j), "0000" & "   " Else s20 = s20 & Format(0, "0000" & "   "
        If i >= j Then s30 = s30 & Format(theMat(i, j), "0000" & "   " Else s30 = s30 & Format(0, "0000" & "   "
    Next j
    s1 = s1 & s10 & vbCr & vbLf
    s2 = s2 & s20 & vbCr & vbLf
    s3 = s3 & s30 & vbCr & vbLf
Next i

MsgBox ("原始值如下:" & vbCrLf & s1 & vbCrLf & "上三角矩阵如下:" & vbCrLf & s2 & vbCrLf & "下三角矩阵为:" & vbCrLf & s3)

End Sub
运行结果如下:
原始值如下:
0001   0002   0003   0004   0005   
0006   0007   0008   0009   0010   
0011   0012   0013   0014   0015   
0016   0017   0018   0019   0020   
0021   0022   0023   0024   0025   

上三角矩阵如下:
0001   0002   0003   0004   0005   
0000   0007   0008   0009   0010   
0000   0000   0013   0014   0015   
0000   0000   0000   0019   0020   
0000   0000   0000   0000   0025   

下三角矩阵为:
0001   0000   0000   0000   0000   
0006   0007   0000   0000   0000   
0011   0012   0013   0000   0000   
0016   0017   0018   0019   0000   
0021   0022   0023   0024   0025
4楼2013-05-25 23:31:22
已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖

ausir

木虫 (正式写手)

稍作修改。 1. theMat的定义只要1 to 5, 1 to 5 就够了。 2. 用Debug.print 可以在即时窗口中显示结果。

Sub Matrix()
Dim theMat(1 To 5, 1 To 5) As Single

Dim s As String, s1 As String, s2 As String, s3 As String, s10 As String, s20 As String, s30 As String

Dim i As Integer, j As Integer

For i = 1 To 5
   For j = 1 To 5
       's = "请输入第" & CStr(i) & "行第" & CStr(j) & "列的数值"
       theMat(i, j) = (i - 1) * 5 + j 'Val(InputBox(s, "")
    Next j
Next i

'MsgBox ("输入完成,按确定后显示输入的阵列。"

s1 = ""
s2 = ""
s3 = ""
For i = 1 To 5
    s10 = ""
    s20 = ""
    s30 = ""
    For j = 1 To 5
        s10 = s10 & Format(theMat(i, j), "0000" & "   "
        If i <= j Then s20 = s20 & Format(theMat(i, j), "0000" & "   " Else s20 = s20 & Format(0, "0000" & "   "
        If i >= j Then s30 = s30 & Format(theMat(i, j), "0000" & "   " Else s30 = s30 & Format(0, "0000" & "   "
    Next j
    s1 = s1 & s10 & vbCr & vbLf
    s2 = s2 & s20 & vbCr & vbLf
    s3 = s3 & s30 & vbCr & vbLf
Next i

s = "原始值如下:" & vbCrLf & s1 & vbCrLf & "上三角矩阵如下:" & vbCrLf & s2 & vbCrLf & "下三角矩阵为:" & vbCrLf & s3

MsgBox (s)
     
Debug.Print s
   
End Sub
5楼2013-05-25 23:34:25
已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖

gyh930912

铁虫 (小有名气)

引用回帖:
5楼: Originally posted by ausir at 2013-05-25 23:34:25
稍作修改。 1. theMat的定义只要1 to 5, 1 to 5 就够了。 2. 用Debug.print 可以在即时窗口中显示结果。

Sub Matrix()
Dim theMat(1 To 5, 1 To 5) As Single

Dim s As String, s1 As String, s2 As String, ...

谢谢!!!
6楼2013-05-27 12:51:30
已阅   回复此楼   关注TA 给TA发消息 送TA红花 TA的回帖
相关版块跳转 我要订阅楼主 gyh930912 的主题更新
最具人气热帖推荐 [查看全部] 作者 回/看 最后发表
[教师之家] 售SCI一区T0P文章,我:8O.55.1.O.54,科目全,可伽急 +3 mNjrFMLoQVIW 2026-11-22 3/150 2026-11-23 05:28 by TU1sx51gX99i
[基金申请] 售SCI一区T0P文章,我:8.O.55.1.O.5.4,科目全,可+急 +3 TxdNP2oT1Q0A 2026-11-22 3/150 2026-11-23 05:05 by TU1sx51gX99i
[公派出国] 售SCI一区T0P文章,我:8.O55.1.O.54,科目全,可十急 +4 TxdNP2oT1Q0A 2026-11-21 4/200 2026-11-23 04:21 by TU1sx51gX99i
[博后之家] 售SCI文章,我:8O.5.5.1O.54,科目全,可十急 +4 TxdNP2oT1Q0A 2026-11-21 4/200 2026-11-23 04:21 by TU1sx51gX99i
[考研] 售SCI一区T0P文章,我:8.O55.1.O.54,科目全,可十急 +3 TxdNP2oT1Q0A 2026-11-21 4/200 2026-11-23 03:59 by TU1sx51gX99i
[硕博家园] 售SCI一区T0P文章,我:8.O.55.1.O54,科目全,可伽急 +3 WHWfk3qcedgw 2026-11-21 3/150 2026-11-23 03:48 by TU1sx51gX99i
[论文投稿] 售SCI-T0P文章,我:8O.5.5.1.O.54,科目齐全,可+急 +4 Gt0XhENGW3Q3 2026-11-21 6/300 2026-11-23 03:15 by TU1sx51gX99i
[考研] 售SCI一区文章,我:8.O.551.O.5.4,科目全,可伽急 +4 YpGmINmR5fp3 2026-11-21 5/250 2026-11-23 02:31 by TU1sx51gX99i
[考研] 售SCI一区文章,我:8O5.5.1.O5.4,科目全,可伽急 +6 K2uSGhxsSAvH 2026-11-21 6/300 2026-11-23 01:58 by TU1sx51gX99i
[考博] 售SCI一区文章,我:8.O.551.O.5.4,科目全,可伽急 +3 K2uSGhxsSAvH 2026-11-21 5/250 2026-11-23 01:58 by TU1sx51gX99i
[基金申请] 售SCI一区文章,我:8O5.5.1.O5.4,科目全,可伽急 +5 Xoz0hXWi9tT1 2026-11-21 6/300 2026-11-23 01:03 by AyQg4gRU5coM
[硕博家园] 售SCI一区T0P文章,我:8O.55.1.O.5.4,科目齐全,可+急 +4 Xoz0hXWi9tT1 2026-11-21 5/250 2026-11-23 00:52 by AyQg4gRU5coM
[考研] 售SCI一区T0P文章,我:8O.55.1.O.54,科目全,可伽急 +5 Xoz0hXWi9tT1 2026-11-20 6/300 2026-11-23 00:41 by AyQg4gRU5coM
[论文投稿] 售SCI文章,我:8O.5.5.1O.54,科目全,可十急 +3 Xoz0hXWi9tT1 2026-11-20 3/150 2026-11-23 00:41 by AyQg4gRU5coM
[考博] 售SCI文章,我:8O5.5.1.O.54,科目齐全,可+急 +3 Xoz0hXWi9tT1 2026-11-21 5/250 2026-11-22 16:25 by 4xQThdVkmqn8
[考博] 售一区SCI文章T0P,我:8O.551.O54,科目全,可十急 +4 YLsF7OSIoYU4 2026-11-21 4/200 2026-11-22 09:49 by HAlUgI97lcPc
[硕博家园] 售SCI文章,我:8O5.5.1.O.54,科目齐全,可+急 +5 Xoz0hXWi9tT1 2026-11-21 5/250 2026-11-22 09:27 by HAlUgI97lcPc
[公派出国] 售SCI一区文章,我:8.O.551.O.5.4,科目全,可伽急 +3 Xoz0hXWi9tT1 2026-11-21 4/200 2026-11-22 03:46 by mNjrFMLoQVIW
[基金申请] 注意啦!用基金购买打印纸、硒鼓、优盘、移动硬盘、个人计算机属于违规了 +3 iaeyuan 2026-11-17 4/200 2026-11-20 09:36 by iaeyuan
[论文投稿] IVD领域内综述投稿推荐 100+3 小小筑梦 2026-11-16 5/250 2026-11-19 17:03 by hansi2025
信息提示
请填处理意见