VBA List Boxes

[Water Dawg]

Hello out there, new to this so bare with me. My question is this: I have 26 pages in a worksheet each representing a paysheet. I would like to list a date from one cell on each of the 26 pages in a list box so the user may select the paydate listed in the list box and then print the corresponding paysheet. I have tried various ways but to no success. I know I can do this by using a range but I would rather list 26 individual cells if that is possible. Any help would be greatly appreciated. Thanks and have a good remaining week.

 

[xld]

Individual cells? Do you mean different cell references, if so, how do you identify which?

 

[Water Dawg]

Yes individual cells. At the top of each page I have a date in a cell that displays the paydate, which is every two weeks. I thought I would use this as a reference not only for the individual to select the pay to be printed but also which page it is associated with for printing purposes.

Thanks for responding.