View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default using record macro, can I stop it to get user input?

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

"CeeDee" wrote:

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