+ Reply to Thread
Results 1 to 5 of 5

VBA Cell change after text/number appears

  1. #1
    Registered User
    Join Date
    09-13-2019
    Location
    Estonia
    MS-Off Ver
    2013
    Posts
    3

    VBA Cell change after text/number appears

    Hello

    I looked up for solutions but did not found it jet, maybe you can help me figure out or at least give me some directions.

    So my problem:
    If text appear in column A/B/C then cursor have to move one right automatically. If Text appears in column D then cursor have to move one down and one left(diagonally). Any advice?


    Thank you for helping me out, probably i have been in office too long.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: VBA Cell change after text/number appears

    What do you mean by the word "appears"?

  3. #3
    Registered User
    Join Date
    09-13-2019
    Location
    Estonia
    MS-Off Ver
    2013
    Posts
    3

    Re: VBA Cell change after text/number appears

    As i enter text or using scanner, same as manually writing or having some basic formula( If Column X contains text then return value etc)

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,026

    Re: VBA Cell change after text/number appears

    Hi and welcome.

    Try this on a worksheet change event

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

  5. #5
    Registered User
    Join Date
    09-13-2019
    Location
    Estonia
    MS-Off Ver
    2013
    Posts
    3

    Re: VBA Cell change after text/number appears

    Hi Crooza

    Thank you for replay, i made small change for Offset numbers and it worked out good.

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 10-16-2015, 12:42 PM
  2. Help with counting the number of times a certain text appears
    By buckles23 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-04-2014, 11:53 AM
  3. [SOLVED] Date appears as number when add text to the end
    By DeeRok in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2014, 12:53 PM
  4. Add the number of times text appears in column
    By paladin7 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-09-2014, 06:11 AM
  5. [SOLVED] formula to auto delete number in dropdown list when number appears in another cell #2
    By ddevins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-28-2014, 08:31 AM
  6. [SOLVED] formula to auto delete number in dropdown list when number appears in another cell
    By ddevins in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-28-2014, 04:54 AM
  7. Change Color Of Text First Time It Appears In A Range
    By ZooTV92 in forum Excel General
    Replies: 5
    Last Post: 10-25-2011, 08:54 AM

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