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
|