View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default VBA to simulate the enter button?

Do you mean in response to something a macro is doing, or just
clicking "OK" during normal interactions with Excel?

Maybe you could provide a specific example of what you would like to
happen.

Tim


"Bob O" wrote in
message ...

Hello All,
I was wondering if there is a way to write vba code that would
simulate
the enter button being pressed at set time intervals? Right now I
have
to hit the enter button for my changes to take affect in Excel but I
really need this to be automatic.

Any help is appreciated,
Bob O


--
Bob O
------------------------------------------------------------------------
Bob O's Profile:
http://www.excelforum.com/member.php...o&userid=26282
View this thread:
http://www.excelforum.com/showthread...hreadid=395692