VBA which works similar to 'comments'

Hi all,

Hope all is well. I don't know whether this is possible or not, I am trying to create a macro which would do the following to any randomly selected cell. So in our example the user would choose a random cell, e.g A1. The macro is run, and as soon as it is run, the following occurs:

Step 1: when the macro is run, it will only work for the randomly selected cell. In this case, A1
Step 2: A pop-up box appears which would prompt the user to input some information. The pop up box should contain a field called: "Subject" and adjacent blank space to write, another field called "Objectives" and adjacent blank space to write additional information.
Step 3: When the user fills the blank space and is ready the 'pop up box' would close.
Step 4: All information written in the pop-up box will be stored (i.e. will not be lost).
Step 5: The user can review the pop-up box (with the additional information inserted in step 3 above) by clicking on that cell again whenever he wants.

In case this sounds very confusing, what I would like to create is something similar to when you insert a comment to a particular cell. That is, you select a cell, insert the comment and you can view the comment again later on.

I don't know whether this could be done or not, so appreciate any feedback or suggestions or alternatives.

Thanks a lot guys, really appreciate all your kind help.

You are probably going to need to use a userform.

You can code a created userform to do about anything. I am not going to build the actual userform for you though (it would need to be created in your real workbook anyways). If you get it created, submit your workbook and I am sure we can generate the code that you requested.