MrYemin09
11-21-2009, 03:17 PM
Hi,
Please teache me how to write VBA code for Detail Box in Excel .I try write code ,but i recevided Name . I will show Detail Box as at the Example.
Please Help me! :(
Example......http://www.sendspace.com/file/h7pjv8 (http://www.sendspace.com/file/h7pjv8)
Sub Detail()
Dim cel As Range
Dim txt As String
For Each cel In Cells(ActiveCell.Row, 1).Resize(, 15)
If cel = ActiveCell.Value Then
txt = txt & cel & vbCr
End If
Next
MsgBox txt
End Sub
Thanks for Help me!:hi:
Please teache me how to write VBA code for Detail Box in Excel .I try write code ,but i recevided Name . I will show Detail Box as at the Example.
Please Help me! :(
Example......http://www.sendspace.com/file/h7pjv8 (http://www.sendspace.com/file/h7pjv8)
Sub Detail()
Dim cel As Range
Dim txt As String
For Each cel In Cells(ActiveCell.Row, 1).Resize(, 15)
If cel = ActiveCell.Value Then
txt = txt & cel & vbCr
End If
Next
MsgBox txt
End Sub
Thanks for Help me!:hi: