Hi there

I've set up a database in Excel where comments can be added to customers accounts via the user form.

Basically, the comment is typed into the text box and it performs a vlookup (so it knows where to past the data/comments).

On the userform I have a button with a label of "Load Comments" which performs a Vlookup and selects the correct comments to load.

Code is as follows:

Please Login or Register  to view this content.
Everytime a new comment is added, it pastes the application user, date and new comment into the last block of cells in my DATA sheet.

What I need is for the VLOOKUP to show all comments (not just columns 22, 23 and 24 - This could be an infinite ammount of comments so I don't really want to add hundred (or throusands of Vlookups) into the View Comments button code. So I think I almost have to offset to check if comments exist then show this on a seperate vbnewline for each block of 3 (application user, date and comment)

Any suggestions on how to do this elegantly?

Also, rather than viewing the comments by clicking the button, I'm also having an issue auto loading the comments upon userform.show under the following code:

Please Login or Register  to view this content.
(The above is the macro for a button on my spreadsheet but I get a debug error on the Vlookup when I paste this into the above).