I need to know what is involved to have a cell from a Excel worksheet and have it sent to a textbox in a app in VB5. Whenever the cell changes the textbox is automatically changed.
Any takers or givers of ideas?
pp
Printable View
I need to know what is involved to have a cell from a Excel worksheet and have it sent to a textbox in a app in VB5. Whenever the cell changes the textbox is automatically changed.
Any takers or givers of ideas?
pp
You could use DDE.
Open the file in Excel, and copy the cell you want.
Open the project in VB
Select the TextBox
In Edit, Click Past Link.
That should do the trick.
That solution doesn't work. When I update the cell no changes show on the text box.
Can you give me the following information about the text box:
LinkItem
LinkMode
LinkTopic