View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Public, Private, Event modules, Forms modules,,,

assume it is typed/declared at the top of the sheet1 (code name) module
outside any procedures

Public MySeq

then in the userform.

v = Sheet1!MySeq

--
Regards,
Tom Ogilvy

"Jim May" wrote in message
news:qzc9f.35503$OM4.8753@dukeread06...
Theis is probably simple, but not to me (at this point)...

If I assign a value (an integer, say 5) to a variable "mySeq" while in an
Event module, say sheet1 and I need to "use it" immediately in Command
button Click event
of a Form frmPOReqEdit, how would I do that?
TIA