View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Deselect Command Button by Selecting another Command Button

Unless I am missing something in your question, you don't need any code to
do that... only one command button at a time will have focus... selecting a
different command button should automatically deselect the previously
selected one.

--
Rick (MVP - Excel)


"gmcnaugh" wrote in message
...
Hi,

I am attempting to automaticlly deselect a focused comand button when
another command button is selected in Excel. I have tried using the
following code:

Private Sub booOVERREAD_Click()
If booOVERREAD = True Then
booUNDERREAD = False
End If

I am a relative novice when it comes to VBA so any help would be
gratefully received.

I thank you.