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.

I bet you could.

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

kyoshirou wrote:

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

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

"Dave Peterson" wrote:

I bet you could.

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

kyoshirou wrote:

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

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.

kyoshirou wrote:

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

"Dave Peterson" wrote:

I bet you could.

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

kyoshirou wrote:

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


--

Dave Peterson