MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

if anyone can help me..

  Asked By: Joao    Date: Nov 29    Category: MS Office    Views: 5246

I want to perform a task that
if i will enter a value in cell (suppose n) and automatically a
worksheet will be open which i want to use
is it possible with or withot macro?



1 Answer Found

Answer #1    Answered By: Iris Sanders     Answered On: Nov 29

What you're talking about is a
Worksheet Change "Event".
the subroutine (or macro) runs whenever any cell  is changed.
What you do within the macro  is check to see if the changed
cell is the one you are watching. If so, then you can do
whatever you need to do to open  the file you want.
That is, if you're planning on entering the file name,
then the macro uses the value of the cell to come up with
the name to supply to the workbook.open command.
Or, you can use a "select case" construct to
do something like: if the user enters "1" then open file#1,
if he enters "2", then open file #2, and so on...
so... what is it exactly that you'd LIKE it to do?
(and how much programming knowledge do you have?)

Didn't find what you were looking for? Find more on if anyone can help me.. Or get search suggestion and latest updates.