+ Reply to Thread
Results 1 to 4 of 4

Vlookup Selected cell

  1. 11-30-2014, 06:56 PM #1
    cajand
    cajand is offline
    Registered User
    Join Date
    08-04-2014
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    58

    Vlookup Selected cell

    Hi,

    I use a code for vlookup, it searches the range "B5" in the sheet "Kalkyl".
    How can I adjust it so that it searches the selected cell instead?

    Thanks in advance! 


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 11-30-2014, 07:11 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Vlookup Selected cell

    Why the need for VBA for this? VLOOKUP() as a standard formula should work just fine for you?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 11-30-2014, 07:16 PM #3
    cajand
    cajand is offline
    Registered User
    Join Date
    08-04-2014
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    58

    Re: Vlookup Selected cell

    Quote Originally Posted by FDibbins View Post
    Why the need for VBA for this? VLOOKUP() as a standard formula should work just fine for you?
    Because the workbook im working on contains many many worksheets with different functions.
    If I did it in formulas it would be very slow,as I experienced, VBA code has made it much better.
    Reply With QuoteRegister To Reply
  4. 11-30-2014, 08:15 PM #4
    cajand
    cajand is offline
    Registered User
    Join Date
    08-04-2014
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    58

    Re: Vlookup Selected cell

    Found a soloution 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] show a certain value in the selected cell based on the selected item no. and month
    By pphg in forum Excel General
    Replies: 2
    Last Post: 01-30-2013, 03:16 AM
  2. [SOLVED] Selected cell doesn't stay selected
    By minifreak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2012, 04:41 AM
  3. Place a tick in a cell when selected, untick it if selected again and....
    By hriggs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-14-2009, 09:09 AM
  4. Using selected cell instead of typing input into vlookup?
    By RWheldon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-26-2009, 10:40 AM
  5. Macro to take selected cells times a selected cell
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2005, 08:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1