Try to do a simple macro

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have not used a macro in excel for many years. I am
rying to do a simple macro to add text to a cell and then
go to the next cell and add the same information to it. I
have tried recording it several different ways and it does
not work. Is there a basic macro web site to learn how to
record macros that work?

Thanks
 
try this

Sub addinfo()
activecell.Resize(2, 1) = _
InputBox("enter whatever") '"hi"
End Sub
 
Back
Top