populate a listbox with dates

[inno101]

Hi,

Does anybody know of a way to populate a list box with dates (52 week commencing dates) using VBA coding rather than populating from a list on a worksheet.

Thanks in advance
Mark

[royUK]

Here's one way

Please Login or Register  to view this content.

[inno101]

Hi Roy,

Thanks for your reply. Works a treat!

Cheers