• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vba find text paste text in message box next cell

martinrusten

New Member
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

file is to large to upload......

thank you
 
Top