View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default Referring to Group name

I think you want to use SetFocus. And you might have to set the focus on
the first check box in the group rather than the group box itself.

--
Jim
"DennisT" wrote in message
...
I have created a group of checkboxes called Group 600 and want to use the
tab
key to go to this from a list box. How do I refer to this group and then
activate it? I think it should be something like below but cannot seem to
get
it to work:

Private Sub TextBox31_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
'This section tabs to the Section C (PIM (Email)Section
If KeyAscii = vbKeyTab Then
KeyAscii = 0
group600.Activate
End If
End Sub

Any help would be appreciated. Thanks.

--
DennisT