Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to store user input in a worksheet?

  Asked By: Darcy    Date: Dec 14    Category: MS Office    Views: 953
  

I was working on a project
which requires to prompt the user for Input, display the user input in the
active worksheet and simultaneously store the value in another worksheet.

Is there a way i can store the values in the second sheet without activating the
worksheet. If so hwo do i select the next cell. The user inputs about 10 data
points which have to be stored in a single row (or column).

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Ramond Fischer     Answered On: Dec 14

Here's how you do it. This will add your variable (which I set here with a
value of 99) to the first free cell  in Column A of Sheet2, without affecting
the Active Cell or the Selection.

myVariable = 99
Sheets("Sheet2").Range("a65536").End(xlUp).Offset(1, 0).Value =
myVariable

 
Didn't find what you were looking for? Find more on How to store user input in a worksheet? Or get search suggestion and latest updates.




Tagged: