MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Contact tracking & option button questions

Posted by Robert Tuck on February 06, 2002 4:36 AM

Is there a way of creating a "hit counter" in excel? I have tried using the tracker in Outlook Journal but it doesn't give me the option of Excel, only Access. Would prefer it be in the spreadsheet anyway.

Also,when using the option buttons in a form, how can I group certaing buttons together? Currently if I have 2 sets of two they act as one big group of 4.

Posted by Derek on February 06, 2002 6:09 AM

comment on the tracking part of your question

This event macro records hits on a worksheet. Presumably you can apply it to openning a workbook

Private Sub Worksheet_Activate()
Range("A1").Value = Range("A1").Value + 1
End Sub


Posted by Juan Pablo G. on February 06, 2002 8:06 AM

About 2.

If you're using Form controls, you'll have to link each group to a cell, that is, first two optionbuttons to A1 and the other two linked to B1.

If you're using Control Toolbar controls, there's a property called GroupName, each option button that belongs to the same group will react to the changes of its group ONLY.

Juan Pablo G.