macro setting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
kalz,
Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "B1"
'...Do you extra validation
Case Else


NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Macro for Creating Word Document!! 5
Macro storing as a date? 11
Macro Related to Paste Values 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Run two macros for two different sheets 11
Datavalidation with shrinking non blank values 1
conditional if statement and macro 6

Back
Top