Yes, thanks, that got me PAST that Line, however I'm
now stopped at the next line with R/T 1004 App...
Holding the cursor over Sheet2.MySeq reads "EMPTY",
probably why it is bombing..
hummmm..
Appreciate your help.
Jim

"Chip Pearson" wrote in message
...
Tom's post had a typo: an exclamation mark where there should have been a
period.

Use
CurrRowNo = Sheet2.MySeq


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jim May" wrote in message
news:sae9f.35513$OM4.33041@dukeread06...
I think I did as you said, but now I'm getting
R/T 438 - Obj doesn't support this prop or meth..

After clicking Debug I'm taken to my user module code
window with highlite covering:
CurrRowNo = Sheet2!MySeq

Any thoughts on what I might try to fix?
TIA,
Jim

"Tom Ogilvy" wrote in message
...
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