macro setting?
 

Hi,

would like some help on running a macro with situational requirement.
e.g. cell B1 is list validated, and if scroll down and choose value "1", it
automatically runs a specified macro to create other validation setting on a
range of cells. if value "B", run marco B. its sth similar as a Button.

How do u think I can get this implemented?
pls help!

thx lots!

macro setting?
 

kalz,
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "B1"
'...Do you extra validation
Case Else


NickHK

"kalz" wrote in message
...
Hi,

would like some help on running a macro with situational requirement.
e.g. cell B1 is list validated, and if scroll down and choose value "1",
it
automatically runs a specified macro to create other validation setting on
a
range of cells. if value "B", run marco B. its sth similar as a Button.

How do u think I can get this implemented?
pls help!

thx lots!