Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referring to Group name
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
Group a range - closing the group does not hide the controls.... | Excel Programming | |||
Sort by Group Header or by Group SubHeader | Excel Programming | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |