Posted to microsoft.public.excel.programming
|
|
Excel macro - Opening a sheet in accordance with the value in a particular cell
Hi
try something like
Worksheets("Sheet" & activesheet.range
("A1").value).activate
-----Original Message-----
this is what i want to do.
the first sheet is named "SheetZero", in it the cell A1
contains a
value which can vary between 1 and 20. SheetZero also
contains a button
with a macro assigned to it.
additionally there are twenty more sheets named Sheet1,
Sheet2, ...
etc., to Sheet20.
when the value in cell A1 in SheetZero is changed, and
the macro is
activated by clicking the button, i want another sheet to
be opened, in
such a manner that it is based on the value in cell A1.
if the value is 1, then Sheet1 should open. if the value
is 2, then
Sheet2 should open. if the value is 3, then Sheet3 should
open... so on
and so forth ... if the value is 20, then Sheet20 should
open.
please help me with the VB code for the macro. i am a
novice in macro
writing, so please help me accordingly.
thanks.
---
Message posted from http://www.ExcelForum.com/
.
|