View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim[_70_] Jim[_70_] is offline
external usenet poster
 
Posts: 5
Default Command Button question

Is there a way to establish whether a command button has been pressed

I wish to execute some code on exiting one control only if a particular
command button had been pressed

Example

Private Sub cbRestaurant_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If command Button pressed Then
Do This
Exit Sub
End If

more code here

End Sub

Regards & TIA