Dumb question of the day.
Hi Dennis,
My Apologies.
I missed the period between the parentheses and, therefore responded to an
imagined question rather than the one you posed.
---
Regards,
Norman
"Norman Jones" wrote in message
...
Hi Dennis,
eg; With ActiveSheet.OptionButtons("Option Button 57")
In the above line:
OptionButtons is the collection of option buttons
"Option Button 57" is a specific option button
and,therefo
ActiveSheet.OptionButtons("Option Button 57")
refers to a control named "Option Button 57", which is a member of the
OptionButtons collection on the active sheet,
---
Regards,
Norman
"DennisB" wrote in message
...
I am relatively new to VBA but am learning fast. One thing that I can't
find the answer to is what is the significance of the (.) in front of a
code.
eg; With ActiveSheet.OptionButtons("Option Button 57")
.Value = Not .Value = xlOn
End With
I cn understand having it between the Not.Value but why is it in the
.Value = etc.
Bewildered semi-Newbie
DennisB
|