Select the Name in the Data Validation list on a cell value then the same name run the sub macro

[sivaprakasam]

Excel VBA code is required to Select the Name in the Data Validation list on a cell value after the same name could be run in the sub macro.

E.g. Data Validation List assigned in "Sheet3" cell text value "B2". if I select the "AA" and then Call to "AA" Sub Marco run. I got error the code line "Application.Run Text".

Below Excel VBA code here: Excel version is 2013

>>> use code - tag <<<

Private Sub Worksheet_Change(ByVal Target As Range)
    'Run Macro when Drop Down value selected
    'VBA to run from Data Validation
    'Auto Show Drop-Down List When Selecting the Cell
    If Target.CountLarge > 1 Then Exit Sub

    If Target.Address = Range("B2").Address Then
        Application.EnableEvents = False

        Dim Text As String
        Text = ThisWorkbook.Sheets("Sheet3").Range("B2").Value
        Application.Run Text

        'or

        'If Target.Address = "$A$1" Then
            'Call ThisWorkbook.Sheets("Sheet3").Range("B2").Value
        'End If
    End If

    Application.EnableEvents = True
End Sub


Public Sub AA()
    MsgBox "AA Macro"
End Sub


Public Sub BB()
    MsgBox "BB Macro"
End Sub


Public Sub CC()
    MsgBox "CC Macro"
End Sub

Thanks for Advance
Sivapraakasam K

 

[vletm]

sivaprakasam​

Have You read somewhere how to use Application.Run?

VBA Macros - Application.Run

VBA Reference - Microsoft Office Add-ins and Consultancy. One website for all Microsoft Office Users and Developers.

bettersolutions.com

Instead of that, I would use something different - which works too.
( while testing Your file with Application.Run, I gotta reboot my Mac )

 

[sivaprakasam]

Thanks for working

 

[Debaser]

FYI, cross-posted:

Select the Name in the Data Validation list on a cell value then the same name run the sub macro

Excel VBA code is required to Select the Name in the Data Validation list on a cell value after the same name could be run in the sub macro. E.g. Data Validation List assigned in "Sheet3" cell text value "B2". if I select the "AA" and then Call to "AA" Sub Marco run. I got error the code line...

www.mrexcel.com

Select the Name in the Data Validation list on a cell value ...

Forum

www.myonlinetraininghub.com

Select the Name in the Data Validation list on a cell value then the same name run the sub macro - OzGrid Free Excel/VBA Help Forum

[cp] https://www.mrexcel.com/board/threads/select-the-name-in-the-data-validation-list-on-a-cell-value-then-the-same-name-run-the-sub-macro.1263786/…

forum.ozgrid.com

Select the Name in the Data Validation list on a cell value then the same name run the sub macro

Excel VBA code is required to Select the Name in the Data Validation list on a cell value after the same name could be run in the sub macro. E.g. Data Validation List assigned in "Sheet3"...

stackoverflow.com

 

[vletm]

sivaprakasam​

You should reread Forum Rules ... from all Your used Forums:

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

 

[sivaprakasam]

O

sivaprakasam​

You should reread Forum Rules ... from all Your used Forums:

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Ohh okay