....Just a few wild guesses :-)

- Use the Worksheet_Change() even to listen for cell value changes
- Check wether or not the target param of the event is (includes?) cell A50
- If it's A50, invoke SendKeys and pass in {ENTER}

Don't know if this will work, but at least it might be a first stab...?

Cheers,
/MP

"Lil Pun" wrote:


I posted some code a little more than a month ago at this thread:

http://www.excelforum.com/showthread.php?t=536944

OK, this Excel program is working with 2-3 other programs as well. One
program, an active X program, puts a 1 into cell A50. After it does
this, I need "enter" some how pressed or activated when that value is
placed into that cell. Is there anyway to acheive this?

What I mean is as soon as the 1 is placed into that cell the program
then acts as if somebody has pressed enter without anybody actually
having to press it.


--
Lil Pun
------------------------------------------------------------------------
Lil Pun's Profile: http://www.excelforum.com/member.php...o&userid=33840
View this thread: http://www.excelforum.com/showthread...hreadid=549138