Re: Form Controls on a Spread***

Sorry to take so long to get back to you. You probably came up with a
solution already.

There would be at least two major ways of doing this.

The first is forms. You have to run the code associated with the form
to do anything. You can autostart it when the *** is open, but it
can get pretty complicated pretty fast.

The second might be easier for you. Use the Worksheet_SelectionChange
event. To see how this works look up work*** in VBA help and there
should be a SelectionChange event listed.

You can use the SelectionChange event to make yes/no checkboxes etc.

The code is associated with a *** and a stub would look like this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

' if check yes
If (Target.Row = 1) And (Target.Column = 4) Then
Call doSomething
End
End If

Hope that helps,
Brian

.