Dynamic spin buttons to change cell link

From the description it sounds like a named range based on offset might work. However, a sample workbook would probably clear things up a lot more.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I am not really happy with this implementation because it is extremely dependent on the setup of the sheet.

For example, it breaks if the spinners are not named "Spinner 1" and "Spinner 2" or if the spinners are not in Columns C & D respectively or if the dates are not in Column B.

I indicated in the code where the changes should be made in the code.

In the thisworkbook module there is an open workbook event. This event runs the code when the workbook is opened, so you don't have to.

Please Login or Register  to view this content.

The main code is:

Please Login or Register  to view this content.

I wish that I could make this more flexible.

Include the workbook so I can see where the error is happening.

You did the right thing, but in the wrong place .

The first bit of code should be in the ThisWorkbook "module"

The main code should not be on the page for the spinners but in a regular module.

The spinners themselves do not need to be associated with the macro.

Here is what happens. When you open the workbook the macro in the ThisWorkbook module runs the main macro run automatically. The main macro looks for today's date (now in column C) and resets the spinners to point to the indicated column on that row.

I moved your code parts to the proper places and reset the spinners to point to row 9 for test purposes. Then I closed the workbook and re-opened it and the spinners were reset to row 11 (for 5/18/2018) - so you nailed it. I did not have to change a thing.

If you want to set the other spinners, that would take a minor adjustment to the code. Looking at how well you adapted this code, I have little doubt you could figure it out.