View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Which button was pressed?



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Adrian" wrote in message
...
I have a custom dialogue that I need to use in two very
different macros. Hence my OKButton_Click routine is empty
except for Unload UserForm, so that the calling macros can
each do their own thing.

But how can the calling macros tell if it was the OKbutton
or the Cancelbutton that was pressed?