Ask Experts Questions for FREE Help !
Ask
    natanab's Avatar
    natanab Posts: 2, Reputation: 1
    New Member
     
    #1

    Jan 7, 2009, 08:38 PM
    I need a macro to respond to a vlookup command
    I understand the basics of Macros programming and have recorded a series of Macros within a workbook. What I want to happen is that when someone chooses an item in a drop down list, depending on which item they choose it will run one of the Macros. If they change their mind it will then run a new macro that will change other parts of the spreadsheet. I am using excel 2007.
    bumble1290's Avatar
    bumble1290 Posts: 10, Reputation: 1
    New Member
     
    #2

    Jan 7, 2009, 09:31 PM

    I want to do exactly the same thing only I'm using excel 2003
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Jan 7, 2009, 09:36 PM

    Macros are fine, but you want to run macros from formulas? That's reinventing the wheel. If you want a macro to run to coincide with something in a cell, put some macro buttons on the screen and just let people "click" them. The first thing the macro does is set that cell to the value you want for that macro, then proceed through the rest of its task.

    So if the box originally had 3 choices in a drop down, just put 3 buttons nearby instead.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #4

    Jan 7, 2009, 09:37 PM
    BTW, tell me what you want happening off those choices, what do these macros do?

    Perhaps macros are also overkill, sometimes formulas are still the best approach to some tasks.
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
     
    #5

    Jan 8, 2009, 06:11 AM
    Check this out. It will do exactly what you asked.

    Run a Macro depending on the value selected from the drop-down list : Visual Basic for Applications (VBA) : Microsoft ISV Community Center : MSDN Forums

    Good luck.
    bumble1290's Avatar
    bumble1290 Posts: 10, Reputation: 1
    New Member
     
    #6

    Jan 8, 2009, 01:52 PM

    Thanks for your replies, upon reflection and messing around with basic marcos yesterday, I think Vlookup might be a better option for what I'm trying to achieve.
    TheCodeCageTeam's Avatar
    TheCodeCageTeam Posts: 4, Reputation: 1
    New Member
     
    #7

    Jan 15, 2009, 05:37 PM
    If you use a formula to reflect chabges across the worksheet remember that these are dependent on the structure of your worksheet remaining constant. Do use a macro if you want to change multiple cells for different values but have them static until the next time you run the code!
    Quote Originally Posted by natanab View Post
    I understand the basics of Macros programming and have recorded a series of Macros within a workbook. What I want to happen is that when someone chooses an item in a drop down list, depending on which item they choose it will run one of the Macros. If they change their mind it will then run a new macro that will change other parts of the spreadsheet. I am using excel 2007.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Command line is telling that "javac" is no internal or external command [ 1 Answers ]

Hi fellow I have just started java , my operating system is windows vista , I have installed java but when I give "javac" command on command line after writng the code in note pad the command line gives an error that javac is not an internal or exetrnal command... if any 1 can help ...

Vlookup what does that mean. [ 3 Answers ]

Can any one tellme.. what does vlookup formula mean in excel...

Vlookup formula [ 2 Answers ]

I am currently using MS-Excel 2003. Having a terrible time with Vlookup. The concept seems easy enough – but I can’t get it to work with just 2 spreadsheets – and pulling only 1 column from the other spreadsheet. I have these fields on one spreadsheet. Worksheet Tab 1 Worksheet Tab 2...

Excel vlookup and auto start macro [ 1 Answers ]

I've set up a vlookuop. I want to retrieve a blank value. Lookupup code is the number 1 and the value for one is blank. At one point it worked fine and now it won't. I've set up a main menu in excelfor excel worksheets in a workbook. When I bookmark a worksheet I would like a macro to autostart...

Limitations of VLOOKUP [ 3 Answers ]

I have a column of values that can't be put in ascending order. 20 55 3 61 2 etc. I want to lookup another value that corresponds to each of these numbers.


View more questions Search