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?

Sub ListBox1_Change(ByVal Target As Range)
  Sheets("Sheet2").Activate
  Range("B4").Value = " 08/01/2024 - 08/18/2024 , 11/11/2024 - 12/01/2024"
End Sub