Assistance with inserting data validation comments

[ABabeNChrist]

I was wondering if I could use this same userform to modify and save an existing comment and/or create a new comment and have it added to the exiting library for that selected dropdown.

I’ve found there are times when I modify or create a new comment that better suits my needs and it would be so much easier with this userform

[HansV]

Is the workbook you last attached (about half a year ago) still up-to-date as far as the structure is concerned?

[ABabeNChrist]

Yes same as post 162375

[HansV]

OK, I'll have a look in a couple of hours.

[HansV]

I have added two new buttons to the userform: "New Comment" and "Edit Comment".

Book1_edit.xlsm

[ABabeNChrist]

I like it, it works great. There is one thing when a new or edit comment is added it goes to the bottom of list. Can they be added alphabetized

[HansV]

Here you go.

Book1_edit.xlsm

[ABabeNChrist]

I like it , thanks so very much Hans

[ABabeNChrist]

I have another question, can the InputBox function be adjusted so that the input bar is larger so as to view complete comment that is entered

[HansV]

No, the InputBox function has a fixed size.
You could use a text box on the userform instead.

[ABabeNChrist]

I searched around before I posted and didn’t find any reference and thought I’d confirm here. Thank you Hans
I think your suggestion makes better since

[ABabeNChrist]

I made some changes as to your suggestion. I added a separate userform/textbox/listbox for modifying an existing comment and adding a new comment. I believe I did it correctly.
I have attached a sample workbook

Book2.xlsm

[HansV]

As far as I can tell, that works well!