View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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