Transferring the Userform Textbox Values To a Single Cell As Comment Indicator

[antzint]

Hi,
I would like to explain my situation first.

Scenario:
I am using a UserForm which has few CheckBoxes and TextBoxes (next to the CheckBoxes). For Instance, the CheckBoxes are considered as criterias which are not fulfilled according to the user. The User checks the criterias and adds Comments in the respective TextBox next to the CheckBox.

My Question:
I need a code to merge the values in the TextBoxes and publish the value as a SINGLE Comment to a Cell.

I would be very grateful if anyone could help me in this regard.
Many Thanks
Kind Regards,
Shiva
UserForm1.jpg

[tkowal]

I added an example to get you started....

Press the Show User Form and whatever textbox Item is checked when the copy to button is pressed those checked items will be copied to the cell entered on the form. The comments will be combined seperated by a ":"

Hope this helps

UserFormExample1.xlsm

If you want to simply place the comments as an indicator
replace the following code:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[antzint]

Hi tkowal,
First of all Thank you
Let me explain you better.
I had prepared a sheet with the scenario. The User will check the CheckBoxes and adds comments to the TextBox next to it.
When the User clicks the Calculate Button in the UserForm, the Value will be published in the Cell B3.
The Help:
I need a code that transfers the text/value in the TextBox(in the UserForm) to the Cell B3 when the User clicks the Calculate Button.
Since, there are four different TextBoxes in the UserForm, It would be better to merge all the Text into one Comment for the Cell B3.Example File.xlsm
I hope I was clear in my explanation.
Requesting your knowledge and help in this regard.
Kind Regards,
Shiva

I added an example to get you started....

Press the Show User Form and whatever textbox Item is checked when the copy to button is pressed those checked items will be copied to the cell entered on the form. The comments will be combined seperated by a ":"

Hope this helps

Attachment 153377

If you want to simple place the comments as an indicater
replace r.Value = Comments with r.AddComment Comments

[revenge4ash8]

Hi Antzint,

I'm not entirely sure if this is what your after, but try the attached.

[tkowal]

???? That is what my code and revenge4ash8 does?? It takes and merges the comments and allows them to be copied to a cell on your worksheet....

[antzint]

Activecell.xlsm
I found a similar solution, Look at this and give your comments
Kind Regards,
Shiva

Hi Antzint,

I'm not entirely sure if this is what your after, but try the attached.

???? That is what my code and revenge4ash8 does?? It takes and merges the comments and allows them to be copied to a cell on your worksheet....