VBA programming exercise

Hi,

I am freshman student and i have this assignment and in I need to get it to work, but I dont know how to do this. Can anyone help me , please?

assignment:

Call up a message box asking if the user would like to give an additional remark. The window has buttons 'yes' and 'no'. If 'yes' is pushed open a form with a text box where the comment is registered. The comment is also entered in cell B2 on Sheet2. If "no" is pressed, the user will get a thank you for his cooperation. Furthermore, nothing happens. Use a public string 'note' to read from the text box on the form and fill in appropriate cell classification. (Dim defines a local variable and is known only within that particular procedure!). Assigning the value "note" occurs each change in the value in the text box.

These are very basic commands. You should look through your book to see the answer and at least attempt it before coming here for help. Once you try it, if it is not working, post up your code, and someone will help you out.

Which bit don't you know how to do?

I think i have the code for calling the message box, besides that i got nothing. I dont know how to put all together so it can work

Have a look in the vba developer help file for the msgbox method. It will give you how to get yes/no buttons.