A user has asked for a change to a macro. In column 26, I have a drop down list with 6 options: (A, B, C, D, E, and F).

A user has asked for a change to a macro. In column 26, I have a drop down list with 6 options: (A, B, C, D, E, and F).

thanks in advance for your help.

I can’t seem to figure out why this doesn’t work, but it does nothing when run. I have the below code under Sheet2(2Weeks) (…right click and pasted in view code window). I have general for the Object choice and ListBox1_Change for the procedure. B4 is a cell with a drop down with a bunch of date ranges. The two date ranges listed below, if selected, should change to a different sheet then the current one. And when switched to the other sheet, the user would be on B4 of the new sheet. The two sheet names are sheet1=2Weeks and sheet2=3Weeks. Would anyone be able to fix this or come up with a totally different code to accomplish this? BTW the “review your question” removed my first line of code… I’m not sure why.. it’s Hi, I can’t seem to figure out why this doesn’t work, but it does nothing when run. I have the below code under Sheet2(2Weeks) (…right click and pasted in view code window). I have general for the Object choice and ListBox1_Change for the procedure. B4 is a cell with a drop down with a bunch of date ranges. The two date ranges listed below, if selected, should change to a different sheet then the current one. And when switched to the other sheet, the user would be on B4 of the new sheet. The two sheet names are sheet1=2Weeks and sheet2=3Weeks. Would anyone be able to fix this or come up with a totally different code to accomplish this?