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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

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,118,764
Messages
5,574,102
Members
412,569
Latest member
kiteifitswindy
Top