Announcement

Collapse
No announcement yet.

vba find text paste text in message box next cell

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    Hello,

    Sadly photos are inert objects ... which cannot be used ...

    Why don't you attach your file for a tailor-made solution ...
    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment


    • #3
      ...
      Last edited by martinrusten; 4 days ago.

      Comment


      • #4
        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

        Comment


        • #5
          Hello,

          To get you started ... attached is your test file with a drafted UserForm ...

          Double-Click will bring up the Form ...

          Hope this will help
          Attached Files
          If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

          Comment


          • #6
            Originally posted by Carim View Post
            Hello,

            To get you started ... attached is your test file with a drafted UserForm ...

            Double-Click will bring up the Form ...

            Hope this will help
            wow thats cool thanks.

            anyway my skill set is way to low for this, i usually make macros by google what i need then frankenstein it together after a long trial and error experience.

            so im afraid i do not have any idea of how to make this macro fint the date registred in the month tabs then find the machine name and then offset the collum and THEN enter the user's text specifyed in your great text box

            Comment


            • #7
              Thanks for your Thanks AND for the Like ...

              Regarding all the steps you need for you development, my recommendation would be to post your request in the ' HIRE HELP ' section ...
              If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

              Comment


              • #8
                Originally posted by Carim View Post
                Thanks for your Thanks AND for the Like ...

                Regarding all the steps you need for you development, my recommendation would be to post your request in the ' HIRE HELP ' section ...

                well its not that many steps. i got all sorted now exept to find the matching machine name and date, on those funktions i get a error, have no clue why


                Attached Files

                Comment


                • #9
                  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 http://www.vbaexpress.com/forum/show...-box-next-cell

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

                  thank you all

                  Comment


                  • #10


                    Glad you have managed to get your problem solved ...
                    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

                    Comment

                    Working...
                    X