So im creating a spin button that connects to a macro. The button would increment a cell by 1 based on the hour of the day and what day of the week it is.
The code im using is:
Sub OneClick()
Dim strTime
Dim LWeekday As Integer
strTime = Time
LWeekday = Weekday(vbUseSystemDayOfWeek)...