vba find text paste text in message box next cell

[martinrusten]

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

 

[martinrusten]

can not see how to attach file here

 

[martinrusten]

here is a few pictures, read description and its clear what i need help for

 

[Fluff]

Cross posted

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all sites you have asked this question on.

 

[martinrusten]

Cross posted

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all sites you have asked this question on.

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:
https://www.ozgrid.com/forum/forum/...find-text-paste-text-in-message-box-next-cell
https://chandoo.org/forum/threads/v...t-in-message-box-next-cell.41201/#post-245746
https://www.mrexcel.com/forum/excel...nd-text-paste-text-message-box-next-cell.html
http://www.vbaexpress.com/forum/sho...find-text-paste-text-in-message-box-next-cell


if this is solved i wil post the link to the forum that solved it and also mark post as solved

 

[martinrusten]

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:
https://www.ozgrid.com/forum/forum/...find-text-paste-text-in-message-box-next-cell
https://chandoo.org/forum/threads/v...t-in-message-box-next-cell.41201/#post-245746
https://www.mrexcel.com/forum/excel...nd-text-paste-text-message-box-next-cell.html
http://www.vbaexpress.com/forum/sho...find-text-paste-text-in-message-box-next-cell


if this is solved i wil post the link to the forum that solved it and also mark post as solved

its also listed here: https://www.excelforum.com/excel-pr...ext-paste-text-in-message-box-next-cell.html?

 

[martinrusten]

Cross posted

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Please supply links to all sites you have asked this question on.

why can i not post my file here?

isnt it hard to make any vba without the basic lyout?

 

[martinrusten]

SOLVED!!!!



big thanks to Christofer Weber that made this work
at https://superuser.com/questions/1414850/vba-find-date-and-enter-userform-text-box/1414900#1414900


and big thanks to 大灰狼1976 that made all the work
at http://www.vbaexpress.com/forum/sho...find-text-paste-text-in-message-box-next-cell


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


thank you all

 

[6StringJazzer]

why can i not post my file here?

isnt it hard to make any vba without the basic lyout?

I see your problem is solved, maybe you will see this post anyway.

MrExcel does not support file uploads and attachments. You can host your file in an online hosting site (e.g., Dropbox, Google Docs) and include a URL link to it in your post.

Likewise you cannot upload images, but you can display an image by linking to the URL of an image hosted somewhere else.