+ Reply to Thread
Results 1 to 8 of 8

Getting cursor from one cell to another cell upon some condition

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Jubail, KSA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Post Getting cursor from one cell to another cell upon some condition

    Dear All, Good Wishes to all and this is my first interaction with you all.
    Please let me know the option and formula for getting the cursor from one cell to another cell conditionally.
    Suppose when I select "Bank" in A1, it should go to the B1 showing "Cheque No:", else the cursor should go to the cell C1 directly where I will select some other contents. So how to take the cursor on this condition from A1 to C1 when it is selected to "Cash", skipping B1.
    Better to have the formula syntax in excel only, other wise we will go for VB program module in last stage.

    Appreciating from all of you the good ideas,
    Thanking you all.
    Marghoob

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,222

    Re: Getting cursor from one cell to another cell upon some condition

    Marghoob ,
    Welcome to the forum. Is this action to only happen when you select A1 or is to happen whenever you select a cell in Column A.

    VBA would be required for this to happen.

  3. #3
    Registered User
    Join Date
    02-06-2014
    Location
    Jubail, KSA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Getting cursor from one cell to another cell upon some condition

    Yes this action to happen whenever we select a cell in Column A.
    Try by Farmula, otherwise go to VBA

  4. #4
    Registered User
    Join Date
    02-06-2014
    Location
    Jubail, KSA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Getting cursor from one cell to another cell upon some condition

    Yes this action to happen whenever we select a cell in Column A.
    Try by Farmula, otherwise go to VBA

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,222

    Re: Getting cursor from one cell to another cell upon some condition

    Can't use a formula for this. A formula cannot perform an action.

  6. #6
    Registered User
    Join Date
    02-06-2014
    Location
    Jubail, KSA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Getting cursor from one cell to another cell upon some condition

    OK, dear by VBA program any possibilty.
    You will be appreciated.
    Best Regards,

  7. #7
    Registered User
    Join Date
    02-06-2014
    Location
    Jubail, KSA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Getting cursor from one cell to another cell upon some condition

    what happened to my query dears, any body can give me the solution for this.

  8. #8
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,222

    Re: Getting cursor from one cell to another cell upon some condition

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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