Public, Private, Event modules, Forms modules,,,

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

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" <jmay@cox.net> 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
>
>

> v = Sheet1!MySeq

Should be Sheet1.MySeq


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




"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:u1YQG0a3FHA.3276@TK2MSFTNGP10.phx.gbl...
> 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" <jmay@cox.net> 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
>>
>>
>
>

Mental gliche

Thanks,

Regards,
Tom Ogilvy

"Chip Pearson" <chip@cpearson.com> wrote in message
news:%23sDenfb3FHA.3400@tk2msftngp13.phx.gbl...
> > v = Sheet1!MySeq
>
> Should be Sheet1.MySeq
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
>
> "Tom Ogilvy" <twogilvy@msn.com> wrote in message
> news:u1YQG0a3FHA.3276@TK2MSFTNGP10.phx.gbl...
> > 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" <jmay@cox.net> 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
> >>
> >>
> >
> >
>
>

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" <twogilvy@msn.com> wrote in message
news:u1YQG0a3FHA.3276@TK2MSFTNGP10.phx.gbl...
> 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" <jmay@cox.net> 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
>>
>>
>
>

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" <jmay@cox.net> 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" <twogilvy@msn.com> wrote in message
> news:u1YQG0a3FHA.3276@TK2MSFTNGP10.phx.gbl...
>> 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" <jmay@cox.net> 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
>>>
>>>
>>
>>
>
>

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" <chip@cpearson.com> wrote in message
news:uQkddlb3FHA.3900@TK2MSFTNGP12.phx.gbl...
> 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" <jmay@cox.net> 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" <twogilvy@msn.com> wrote in message
>> news:u1YQG0a3FHA.3276@TK2MSFTNGP10.phx.gbl...
>>> 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" <jmay@cox.net> 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
>>>>
>>>>
>>>
>>>
>>
>>
>
>

MySeq is created in a Before Double-Click Event
which after performing certain code ends with
Cancel = True;
Does that matter?
Jim

"Jim May" <jmay@cox.net> wrote in message
news:kte9f.35525$OM4.16202@dukeread06...
> 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" <chip@cpearson.com> wrote in message
> news:uQkddlb3FHA.3900@TK2MSFTNGP12.phx.gbl...
>> 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" <jmay@cox.net> 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" <twogilvy@msn.com> wrote in message
>>> news:u1YQG0a3FHA.3276@TK2MSFTNGP10.phx.gbl...
>>>> 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" <jmay@cox.net> 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
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>