It sounds like you want a certain cell on your worksheet to have a drop down list of Tuesday dates. You don't need VBA for this. To accomplish this, follow these steps and please read carefully.
Step 1
From your worksheet, right click the sheet tab and select Insert > Worksheet. Double-click the new worksheet's sheet tab and enter "Dates" (without the quotes). This means, now you have created a new sheet and you have named it "Dates".
Step 2
In cell A1 of your new Dates sheet, type in
7-5-2011 (without the quotes)
and press the Enter key.
This means, you just entered the date of July 5, 2011 into cell A1 of the Dates worksheet and now your active cell is A2.
Step 3
Take a close look immediately above cell A1, which has the "A" column header. Immediately above that is a small box that is called the name box. Right now, it will say A2 because that is your current active selected cell. Use your mouse to click in the name box. Type in "A53" (without the quotes), hold down the Shift key, and while the Shift key is held down, press the Enter key. That will select range A2:A53. Take your hands off the keyboard.
Step 4
Press the F2 key.
Step 5
Type in
=A1+7 (without the quotes), hold down the Ctrl key, and while the Ctrl key is held down, press the Enter Key. This will enter all the dates from July 12, 2011to July 3, 2012 in column A. Take your hands off the keyboard.
Step 6
From the worksheet menu, click Edit > GoTo > Special > Current Region > OK. This will select A1:A53.
Step 7
From the keyboard, press Ctrl+C.
Step 8
Right-click anywhere in A1:A53 and select Paste Special > Values > OK.
This will make all the formulas as constants.
Step 9
Press the Esc key to exit Copy mode.
Step 10
Range A1:A53 is still selected.
Click in the name box again and type in
"mydates" (without the quotes) and hit the Enter key.
Step 11
Optionally hide your Dates sheet from the Home tab in the ribbon.
Step 12
Go to your worksheet of interest and select the cell where you want this drop-down to appear with the Tuesday dates.
Step 13
Press Alt+D+L to call the Data Validation dialog box and go to the Settings tab (or from the ribbon, Data tab, Data Tools section and find Data Validation).
In the Allow field, click List.
In the Source field, type in "=mydates" (without the quotes).
Optional, you may enter text in the Input Message tab or Error Alert tab depending on what you want your users to respectively see when they select that cell or try to enter a value in that cell that is not among the listed dates.
Click OK to exit the Data Validation dialog.
Step 14
Your data validated cell is still selected and now shows a drop-down arrow.
From the worksheet menu, click on Format > Cells > Number.
In the Category pane, select the Date item and choose a date format that you want the drop-down items to look like, and click OK.
Step 15
Now your cell, when selected, has a drop-down arrow that when you click on it, will let you select the list of Tuesday dates for the next year, displayed in the format you chose in Step 14.
