Forum Discussion
Solved
Button To Navigate In Excel
I've tried to find something that might work for this but have been unable to find anything. My work we use excel to manage our schedule and everyone's appointments and whatnot. We have a row wit...
I didn't read your initial question carefully enough.
Assuming that the dates are in row 1, assign the following macro to a Form Control command button:
Sub Button1_Click() Application.Goto Rows(1).Find(What:=Date, LookIn:=xlFormulas), True ActiveCell.EntireColumn.Select End Sub
HansVogelaar
Thank you for this, I realize I asked the question unclearly and have updated it.
I'm not looking to highlight the row as in formatting. I'd like a button in the area of A1 that is fixed on our sheet where you click it to navigate to that column. So say I'm scrolled over into next year, a button that would take me back to the column for today within the sheet
Thank you for this, I realize I asked the question unclearly and have updated it.
I'm not looking to highlight the row as in formatting. I'd like a button in the area of A1 that is fixed on our sheet where you click it to navigate to that column. So say I'm scrolled over into next year, a button that would take me back to the column for today within the sheet
I didn't read your initial question carefully enough.
Assuming that the dates are in row 1, assign the following macro to a Form Control command button:
Sub Button1_Click()
Application.Goto Rows(1).Find(What:=Date, LookIn:=xlFormulas), True
ActiveCell.EntireColumn.Select
End Sub- Thank you so much! Exactly what I was looking for.