VBA Code to Concantenate Two Columns to Userform Textbox

I'm thinking the solution to this is simple enough but I'm perplexed. I can't attach the main spreadsheet because there are some security concerns but my problem can be explained in generic terms. I need to concatenate two columns from the activesheet to a textbox on a userform. In column A2 thru A14 I have Cycles 1-13 (Cycle 1, Cycle 2,...Cycle 13). I also have times for each of those Cycles in H2 thru H14. I'm having problems with this alone, but on the same spreadsheet the whole situation is repeated after skipping a few rows (A20-A30 Cycles & H20-H30 Times) which probably complicates things more. I'd like the layout in the textbox to resemble this...

Cycle 1 - 12:00 pm
Cycle 2 - 1:00 pm
Cycle 3 - 4:00 pm
Cycle 15 - 6:00 pm
Cycle 20 - 9:00 pm
...and so on

I've searched the forums and tried modifying the code I found to suit my needs but to avail. I'd appreciate any assistance. I created a simple spreadsheet as an example just in case my explantion is not concise enough. Thanks in advance.

What exactly is the problem?

Also, couldn't you use a listbox to display the data?

Sorry but the title doesn't really explain what you are having problems with.

Is it locating the data? Concatenating? Displaying it in the textbox?

This code will put the data from Sheet1 in your workbook in TextBox1 of a userform with each 'cycle' on a new line.

Please Login or Register  to view this content.

If you just want to check there's something in column A change the If statement to this.

Please Login or Register  to view this content.