| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to run when validation choice selected
Works like a charm! Thanks for the help...
"Bob Phillips" wrote: .... for example Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "H10" '<== change to suit On Error GoTo ws_exit Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target ' do your stuff End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click -- --- HTH Bob (change the xxxx to gmail if mailing direct) "galimi" wrote in message ... You need to add a change event to the sheet in question and have it react only to the specific cell that is performing data validation. -- http://HelpExcel.com "JDay01" wrote: Hopefully this is a simple question.... I need to have a macro run automatically when a user makes their selection from a data validation drop-down box. The macro name is Hide_Columns. What is the code needed to execute this macro upon their selection? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E-mail macro - Field Validation | Excel Discussion (Misc queries) | |||
| Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
| Running a Macro when a single cell is selected | Excel Discussion (Misc queries) | |||
| Perform oiperations relative to initial selected cell | Excel Discussion (Misc queries) | |||
| Passing selected workbook name and values to a macro | Excel Worksheet Functions | |||
Threaded Mode
