+ Reply to Thread
Results 1 to 5 of 5

vba find text paste text in message box next cell

  1. #1
    Registered User
    Join Date
    09-03-2016
    Location
    norway
    MS-Off Ver
    2007
    Posts
    7

    vba find text paste text in message box next cell

    hello, my skills is not enough to finnich my project.
    i got a work task sheet, and i need the finniched work to register on the correct cell in the correct month sheet

    i need a vba to look for the same date as in cell J6 - J46 (the selected row/cell in that range)
    look for the same text as in L6 - L 46 (the selected row in that range)
    vba need to find the text and date in the sheets: Januar Februar Mars April Mai Juni Juli August September Oktober November
    dates is lokated in range D3 - DU3
    text is located in range B6 - DU17

    when the cell with the same text is found i need the vba to input user spessifyed text in message box in the collomn to the right for the text that was found.

    example:
    J6 contains date 13/3/19 (dd-mm-yy)
    L6 contains text hello
    vba find this date in sheet Mars AX3
    vba find this text in sheet Mars AX6

    (this is to end work task and user need to input what is done)
    vba ask user for what is done (in text box)
    vba then paste the users text in the cell to the right, AY6
    vba ask user what date work was done and paste this date in 2'nd cell to the right AZ6 (dd-mm-yy)
    vba ask user for name and paste the name in the 3'nd cell to the right BA6
    all this would be nice to have in the same text box


    when name is entered in BA6 the task is not longer present in the Dagplan sheet (its done by formula no vba needed)
    i can not change anything bechause its all connected to other workbooks and the tasks come from other workwooks, but work done is registred in this workbook.

    hopefully someone could help with this

    thank you

  2. #2
    Registered User
    Join Date
    09-03-2016
    Location
    norway
    MS-Off Ver
    2007
    Posts
    7

    Re: vba find text paste text in message box next cell

    turns out that its not so easy to understand only by text so i had to translate and simplyfy the sheet. here it is
    Attached Files Attached Files

  3. #3
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,116

    Re: vba find text paste text in message box next cell

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    09-03-2016
    Location
    norway
    MS-Off Ver
    2007
    Posts
    7

    Re: vba find text paste text in message box next cell

    im so sorry, totally my fault to not read the forum rules..


    yes i put this up to several forums bechause i would like to solve it quickly, and it do not seems like its a lot of peoples out there that can solve this
    so i was upping the ods.

    here is the forum links:

    im not allowed to post links so had to modify them

    https://www.ozgrid.com/forum/forum/h...-box-next-cell
    https://chandoo.org/forum/threads/vb...1/#post-245746
    https://www.mrexcel.com/forum/excel-...next-cell.html
    http://www.vbaexpress.com/forum/show...-cell-box-next


    if this is solved i wil post the link to the forum that solved it and also mark post as solved
    Last edited by 6StringJazzer; 03-15-2019 at 10:02 PM. Reason: links activated by Moderator

  5. #5
    Registered User
    Join Date
    09-03-2016
    Location
    norway
    MS-Off Ver
    2007
    Posts
    7

    Re: vba find text paste text in message box next cell

    SOLVED!!!!!



    big thanks to Christofer Weber that made this work
    at https://superuser.com/questions/1414...414900#1414900

    and big thanks to 大灰狼1976 that made all the work
    at https://vbaexpress.com/forum/showthr...-box-next-cell

    if someone need to download the complete file, the working file is located on the vbaexpress forum

    thank you all
    Last edited by 6StringJazzer; 03-23-2019 at 10:20 AM. Reason: links activated by Moderator

+ 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. [SOLVED] Find and match cell text value on another sheet and paste row on correct row number
    By smashthegas in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-21-2016, 07:53 AM
  2. [SOLVED] Find Text - Copy Range Below - Paste to Cell
    By keen2xl in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-02-2014, 05:39 AM
  3. [SOLVED] Find text in column A then copy the cell to the right and paste it in sheet2
    By Alring in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-22-2013, 02:11 AM
  4. Replies: 0
    Last Post: 11-06-2012, 06:44 PM
  5. Find the specific text and copy and paste in another cell only if true.
    By SHARIB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2012, 03:14 AM
  6. find text and cut/paste cell below
    By treur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 07:46 AM
  7. [SOLVED] Find text, if not paste in the first blank cell
    By Birnen in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-12-2012, 10:02 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