| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro picture setting | Excel Discussion (Misc queries) | |||
| Setting up a Macro | Excel Worksheet Functions | |||
| Setting up a macro to print? | Excel Worksheet Functions | |||
| Sending email via macro- setting the importance setting. | Excel Programming | |||
| setting row in macro | Excel Programming | |||
Linear Mode
