macros entering data

C

carrie

How do I create a macro that goes to one cell
then waits until I enter new data, then goes to another cell
and waits until I enter new data etc?

thanks
 
D

Dave O

How about something like

sub Enter_Data()
dim NewValue

NewValue = inputbox("Enter the value for cell A1: ")
range("a1").value = NewValue

NewValue = inputbox("Enter the value for cell G2: ")
range("g2").value = NewValue

NewValue = inputbox("Enter the value for cell I8: ")
range("i8").value = NewValue

end sub
 
Top