realbeginner
Technical User
Hi. I'm making an EXCEL register with buttons to use on an interactive whiteboard in the classroom. I'm almost there but I'm stuck on the last two bits:
- Could you show me how to click a button to input today's date so that it stays as that date (i.e. not a function)
- Could you see what I've done wrong in the code below which should just change the colour of the button:
CODE
Sub Button1_Click()
'
' Button1_Click Macro Present
With ActiveCell
.Formula = "1"
.Offset(1, 0).Select
End With
Button1.ForeColor = RGB(0, 255, 0)
' Colour - Green
End Sub
Many thanks!
- Could you show me how to click a button to input today's date so that it stays as that date (i.e. not a function)
- Could you see what I've done wrong in the code below which should just change the colour of the button:
CODE
Sub Button1_Click()
'
' Button1_Click Macro Present
With ActiveCell
.Formula = "1"
.Offset(1, 0).Select
End With
Button1.ForeColor = RGB(0, 255, 0)
' Colour - Green
End Sub
Many thanks!