Simple excel macro help

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I have recorded a simple macro for data entry that moves to the right
several cells, entering info in each and then returning to the
starting column.

I need to know how to provide for user input at each cell stop across
and then when it returns to the starting column to have it loop until
data is finished

Can anyone provide a simple answer to this? It used to be easy to do
this in Lotus way back but I have not done it for a while.

Thanks
Fred
 
As usual you should post your efforts (not a workbook attachment) for
comments and suggestions. You do not have to physically move to each cell to
enter data in the cell

range("a3")=inputbox("Enter data1 desired")
range("a3").offset(0,1)=inputbox("Enter data2 desired")
etc
 
Back
Top