I have 2 option boxes. One captioned "Run macro after export" and named "runmacro". And the 2nd captioned "Yesterday" and named "yestsel". I am trying to run a simple script to say
Code:
if runmacro.checked = true then
or
Code:
if yestsel.checked = true then
but I keep getting errors saying "Object required" or "Object does not support this property or method"
Here is my actual code:
Code:
Function ChosenOptions()
If runmacro.Checked = True Then
runmacexp = True
End If
If yestsel.Checked = True Then
fromdate.Value = "Date()-1" And todate.Value = "Date()-1"
End If
End Function