Lol ok sorry guys I get the idea...right basically the steps I followed to get my solution was probably the simplest route I could find. The steps were:
1) Create the list of items I needed and then concatenate the coloumns if there was more than one list using the =$[cell reference]&" "&$[cell reference] concatenator. That way the "table" that I wanted to put into the listform can be displayed easily.
2) Then name the concatenated list under Insert -> Name -> Define
3) Then for each list that I had I created a userform and then a listform inside each userform and set the rowsource property to "=[defined name]" for the listform to populate the list.
4) I then placed the following code inside each userform so that it could link to the next userform as I had multiple useforms to display:
5) Then I placed the following code inside the user entry input screen sheet so that whenever the user clicked the cell C5 the userform would display.
6)Then in order for the user to enter the information from the list into the cells C5 and C6, the final userform had the following code. It contained 2 functions, one to enter the text into cells C5 and C6 to hide the data and a split_text function to help split the text back up in the listform, using 3 spaces as the seperator:
And that was it. I hope that all makes sense. Due to the nature of the spreadsheet containing sensitive data I am unable to attach it to this post to show everyone what I did, but i hope the steps above showed what I did. I'm also very hungover at the moment so if some of it (or all of it), doesnt make sense then let me know. I'm also very appreciative of all the help received so far in this excel forum.
Cheers,
Jag
Bookmarks