View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre Leclerc Pierre Leclerc is offline
external usenet poster
 
Posts: 1
Default Entering data while procedure is on

HI

Here is my problem

My procedure goes:
ActiveCell.Offset(3, 8).Select
and then I would like to be able to enter manually a value in the
activecell. Once the value is in, I would want the procedure to go on
ActiveCell.Offset(6, 3).Select
and so on and so on

The problem is being able to enter a value in the activecell between
each vba step.

How do I go about?

Thanks
Pierre Leclerc
http://www.excel-vba.com