using record macro, can I stop it to get user input?

  • Thread starter Thread starter CeeDee
  • Start date Start date
C

CeeDee

If I am creating a macro using the macro recorder and not entering lines
using VBA can the process be stoped to allow a user to input information?
Like text, numbers or cell references?
Thanks
CeeDee
 
hi
the recorder records your actions on the keyboard and mouse only. if you
want your users to have the ablility to input data, you would have to do some
editing of the recorded macro afterwards to add an inputbox.
dim str as string
str = inputbox("Enter something")
if you are unfimilar with the inputbox, read up on it in vb help.

regards
FSt1
 
Back
Top