shahidmojid Level: Professor
 Registered: 09-05-2002 Posts: 85
|
Re: using DDE to display stock quote Archived to Disk
Hi Alex,
How come you r updating your text box before link. See this example, it might help you:
Private Sub Form_Click()
If Text1.LinkMode = vbNone Then ' Test link mode.
Text1.LinkTopic = "Excel|Sheet1" ' Set link topic.
Text1.LinkItem = "R1C1" ' Set link item.
Text1.LinkMode = vbLinkManual ' Set link mode.
Text1.LinkRequest ' Update text box.
Else
If Text1.LinkItem = "R1C1" Then
Text1.LinkItem = "R2C1"
Text1.LinkRequest ' Update text box.
Else
Text1.LinkItem = "R1C1"
Text1.LinkRequest ' Update text box.
End If
End If
End Sub
|