I've developed a program that captures data from a hardware device (scale, multiplexer, & a magna mike) and displays the output to Excel. When the user presses the 'Get Reading' button or preses the F5 key, the data is then transfared to Excel (which is OK), but I would like the focus to go back to Excel so the user knows what cell they are on. I've tried IsFrontmost, TopMost & NotTopMost, changed the Window settings to Floating and Modal and I can't get the focus to go back to Excel.
Any ideas on what I should look for?
- Eric