+ Reply to Thread
Results 1 to 8 of 8

Code to make an excel cell work like F2 command in Computer

  1. 05-12-2015, 01:36 PM #1
    boddulus
    boddulus is offline
    Registered User
    Join Date
    08-28-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    92

    Question Code to make an excel cell work like F2 command in Computer

    Hi all,

    I am not sure if it is possible or not.

    Could some one help me with as code which can make an excel cell work like F2 in System.

    What i am trying is i wrote a macro where my excel has to run against my application and in between i have to press F2 function to go to other screen .so is it possible to do it with excel cell which can work like F2.

    Thanks in Advance.Please help me out if it is there.
    Reply With QuoteRegister To Reply
  2. 05-12-2015, 09:01 PM #2
    boddulus
    boddulus is offline
    Registered User
    Join Date
    08-28-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    92

    Re: Code to make an excel cell work like F2 command in Computer

    Hi Any luck on the above.If it dosen't have VBA to do this, excel formula is fine for me
    Reply With QuoteRegister To Reply
  3. 05-12-2015, 09:13 PM #3
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Code to make an excel cell work like F2 command in Computer

    Similar recent post.

    You could also record a macro and get the code.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
    Reply With QuoteRegister To Reply
  4. 05-12-2015, 09:31 PM #4
    boddulus
    boddulus is offline
    Registered User
    Join Date
    08-28-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    92

    Re: Code to make an excel cell work like F2 command in Computer

    Hi Skywriter, Thanks for the reply .

    I tried to record the macro the code i am getting is 
    Please Login or Register  to view this content.
    I am not able to understand the code you gave in the above link can you please help me out on this ? i just want cell to work like F2 and enter is it possible with excel formula ?
    Thanks in advance....
    Reply With QuoteRegister To Reply
  5. 05-12-2015, 09:40 PM #5
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Code to make an excel cell work like F2 command in Computer

    Quote Originally Posted by boddulus View Post
    Hi Skywriter, Thanks for the reply .

    I tried to record the macro the code i am getting is 
    Please Login or Register  to view this content.
    I am not able to understand the code you gave in the above link can you please help me out on this ? i just want cell to work like F2 and enter is it possible with excel formula ?
    Thanks in advance....
    I don't know. You would have to read all the posts and see if they ever came up with a solution. There were several posts and I don't know what the outcome was.
    Reply With QuoteRegister To Reply
  6. 05-12-2015, 09:59 PM #6
    boddulus
    boddulus is offline
    Registered User
    Join Date
    08-28-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    92

    Re: Code to make an excel cell work like F2 command in Computer

    ok fine thanks for the help.....

    Is there any excel formula which can make an excel cell in to F2 and enter ?
    Reply With QuoteRegister To Reply
  7. 05-12-2015, 11:24 PM #7
    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,933

    Re: Code to make an excel cell work like F2 command in Computer

    Short answer - no, formulas cannot do that
    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
  8. 05-13-2015, 09:40 AM #8
    Large114
    Large114 is offline
    Registered User
    Join Date
    05-12-2015
    Location
    Cali, Colombia
    MS-Off Ver
    2013
    Posts
    2

    Re: Code to make an excel cell work like F2 command in Computer

    And a SendKeys method doesn't work?
    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] Can someone help me make this code work? Moving cell contents if cell has date format...
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 04-12-2015, 05:29 PM
  2. Converting vba code in Excel XP to make it work in Excel 2010
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 08:43 AM
  3. Vba in Excel 2007 to copy a pdf from computer to ftp, using FileCopy command
    By dbocz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2012, 06:32 PM
  4. Nest SUM command with a command to make result cell blank
    By dwest185 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2011, 08:10 PM
  5. Auto Filter on my home computer differs from my work computer.
    By Sbova0226 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-08-2009, 03:04 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