Thread: Userform close
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Howard Kaikow Howard Kaikow is offline
external usenet poster
 
Posts: 269
Default Userform close

"Nigel" wrote in message
...
They are essentially the same, vbFormControlMenu refers to the 'X' as the
mode of closing. CloseMode = 0 is the same. Cancel = 1; evaluates to
True.

I use, CloseMode = 0 and Cancel = True


Cancel is an Integer data type, so Cancel = 1 is the preferred coding.

Shhh, don't tell anyone, this is a secret, I've probably done it both ways.