Good day I am currently working on a data entry spreadsheet that checks the values entered against a set of if statements to determine if the value is potentially correct. Based on the error code returned by each line I have a help button (form control) that I am currently creating macros for each line like so

Please Login or Register  to view this content.
where I need to create a section like that for each line (around 300 lines) and have it do the help text for each error code. now each line will have unique help text but I'm wondering if there is a more efficient way to handle this on such a large scale as this part of the file alone will end up around 5000 lines of VBA the way I'm going.

Any assistance would be greatly appreciated.