Need a message box to appear before pasting data from another worksheet.

[Bobp84]

I currently have a button in a spreadsheet that pastes data from another worksheet, here is the code I have running. I would like a message box to appear with two buttons, one button would say WO# and the other would say Problem. The message box would say, "Where would you like to input the data". The WO# button would insert the data in I1 and the probem button would insert the data in A7. Attached is the code that is currently running with the button, any help would be appreciated.

Please Login or Register  to view this content.

[patel45]

Msgbox can not have 2 buttons, you need a userform

[Tinbendr]

Since you don't provide details about filenames and sheet names, I had to use activesheet.

Make sure the log file is open when you run this from the destination workbook.