PDA

View Full Version : msgbox content redirect



asddsa88
05-04-2011, 05:19 AM
Hello,

I would like to have the message displayed in a msgbox also written to a cell or copied to the clipboard

here is the msgbox I am using:

sMessage = ""
For Each Res1 In Res1
sMessage = sMessage & CStr(Res1.Value) & vbCrLf
Next Res1
MsgBox sMessage

is this possbile?

Bob Phillips
05-04-2011, 05:45 AM
sMessage = ""
For Each Res1 In Res1
sMessage = sMessage & CStr(Res1.Value) & vbCrLf
Next Res1
MsgBox sMessage
Range("H1").Value2 = sMessage

asddsa88
05-04-2011, 07:42 AM
works great :)

thanks!