Thread: macro question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wooo wooo is offline
external usenet poster
 
Posts: 3
Default macro question

I want to type data in range("A1") and then click ENTER,
how to create a macro that when I click ENTER button, the
range will be changed to range("B1") to let me type data.

and then when I finished to type data in A1 & B1, I want
the range could be changed to next row to range("A2",
also will be changed to range("B2") after click ENTER.

how can I make a macro for this repeated procedure.