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: 2004

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).



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 =

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.