addComments

[Guest]

http://www.contextures.com/xlUserForm01.html

within above sample, is it possible to when click on "Add this part", it
will pop out a box called "Add comments" for users to add comments. And the
comments will be capure inside the new worksheet.

Thanks.

 

[Dave Peterson]

I bet you could.

But wouldn't it be better to just add another textbox to the userform that could
be used for comments.

 

[Guest]

some1 request to have the comments seprate. That y..
any helps.?

 

[Dave Peterson]

Use inputbox() to retrieve a comment and then use that to populate the cell.

dim myStr as string
....

mystr = inputbox(Prompt:="Enter a comment")
....

Then use that mystr variable to fill in the cell that you want.