Excel Scroll Bar Control - Shift Current Value

leen1234

New Member
Joined
Sep 22, 2020
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
Hello, I added a scroll bar control on my excel file to add a gant chart. I would like to shift the current value my scroll bar is on based on today's date., I am using Excel 2013 Could anyone please help me.


Thank you
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

padapinto

New Member
Joined
Sep 21, 2020
Messages
42
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
add a formula with conditional format that high lights the current date in your chart
 

Watch MrExcel Video

Forum statistics

Threads
1,119,235
Messages
5,576,886
Members
412,751
Latest member
ausrollo
Top