Populate Cell Comment text in UserForm TextBox

[pipoliveira]

Dear All,

I hope you're all well.

I have a table with huge amount of data. I use a UserForm with textboxes to populate the information of the required row.

There's a Comment Box text on a specific cell that I need to populate on one of the textboxes but I am unable to do it.

The code I have that works well, populates the cell content:

Please Login or Register  to view this content.

Now, on that cell, there's a comment text that I need it populated as well on another textbox but it doesn't work. I tried:

Please Login or Register  to view this content.

But this doesn't work.

Any ideas will be highly appreciated.

Kind regards,
Filipe

[Norie]

Use Match to find the row of the cell with the comment.

Please Login or Register  to view this content.

[pipoliveira]

Hi Norie,

Thanks for your help once again

The code you sent did not worked unfortunately as I've received the following error:

"Object Variable or With block variable not set"

The same error I got with the above mentioned code.

Don't know if that makes difference but the Comment text will be on column "D".

Thanks in advance.

Regards,
Filipe

[Norie]

Filipe

The original code you posted would error because Application.Vlookup returns a value not a range.

The code I posted could be erroring because there is no comment in column D.

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[pipoliveira]

Hi Norie,

Please find Example file attached.

In Sheet1 you can see a small table that is named as "TableRange".

Once clicking the "View Reference" you need to choose the reference from ComboBox to populate data.

In cell C10, there's a comment that I need it populated on the UserForm TextBox31 in case I choose that reference (in that case, reference "006").

Please let me know if you need further clarification on this matter.

Many thanks in advance and kind regards,
Filipe Oliveira.

[Norie]

The comment is actually in column 2 (column C of the worksheet) of the range, the range is called 'TableCheck' not 'RangeCheck' and the combobox is 'ComboBox3.

Try this.

Please Login or Register  to view this content.

[pipoliveira]

Thanks Norie,

Yes, you are right, but the file I've attached is an example so the references changed, sorry.

The code worked perfectly if I choose the reference that has a comment but if I choose other one without comments, it gives me the same error message as before:

"Object Variable or With block variable not set"

Maybe we should use other IF criteria?

Thanks a million.
Filipe

[Norie]

Filipe

To deal with there not being a comment try this.

Please Login or Register  to view this content.

[pipoliveira]

Thanks Norie,

That worked perfectly!

Thanks a million once again to help me out.

Really appreciated.

Best regards,
Filipe.