Results 1 to 2 of 2

i want to control two drop down lists to tell which macro to be run automatically

Threaded View

Jagadeshrao i want to control two drop... 03-29-2024, 03:12 AM
Kaper Re: i want to control two... 03-29-2024, 03:45 AM
  1. #1
    Registered User
    Join Date
    09-25-2023
    Location
    Chennai, India
    MS-Off Ver
    365
    Posts
    26

    i want to control two drop down lists to tell which macro to be run automatically

    Currently i have this code

    Private Sub Worksheet_Change(ByVal Target As Range)
    
    Application.EnableEvents = True ' <-- just for tests
    If Not Intersect(Target, Range("C1")) Is Nothing Then
      Select Case Target.Value  
       Case "Expander 1 eff"     
          CopyIncreaseRecord      
          Case "Expander 2 eff"  
         CopyIncreaseRecord       
          Case "Pump eff"  
           CopyIncreaseRecord     
          Case "Net Power"  
          CopyIncreaseRecordNetPower      
       End Select 
    End If
    
    End Sub
    under the Sheet5 (Graph1) view code.

    presently i'm using one drop down in cell C1 to tell which macro to run automatically when i select an option in cell C1,

    now i want to have two drop downs in cell C1 & in cell C2, for example if C1 is selected "Expander 2 eff" and C2 is selected "Cycle eff" i want macro Expander2effvsCycleeff to run if C1 is selected "Expander 2 eff" and C2 is selected "Massflowrate" i want macro Expander2effvsMassflowrate to run.

    pls help, thanks in advance

    i tried AI but it is not giving me the selection in two cells to be met
    Last edited by AliGW; 03-29-2024 at 03:51 AM. Reason: Code tags added - please review the forum guidelines.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 10-14-2021, 02:32 AM
  2. [SOLVED] Drop lists to control pivot table
    By Peter Eerdekens in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2017, 02:37 AM
  3. Replies: 5
    Last Post: 12-23-2016, 10:12 AM
  4. Automatically populating a value based on several drop down lists
    By JStrawn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2015, 05:27 AM
  5. [SOLVED] Excel Updates have stopped vba coding from working and control boxes (drop down lists)
    By vkamp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2015, 09:25 AM
  6. How to control user input on a multiple drop down lists?
    By rashedexcel2013 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2013, 02:04 PM
  7. drop down lists referencing tables creating other drop down lists!!
    By Stumped- in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-07-2009, 11:29 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1