Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public, Private, Event modules, Forms modules,,,
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public, Private, Event modules, Forms modules,,,
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public, Private, Event modules, Forms modules,,,
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public, Private, Event modules, Forms modules,,,
MySeq is created in a Before Double-Click Event
which after performing certain code ends with Cancel = True; Does that matter? Jim "Jim May" 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" 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public, Private, Event modules, Forms modules,,,
v = Sheet1!MySeq
Should be Sheet1.MySeq -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Public, Private, Event modules, Forms modules,,,
Mental gliche
Thanks, Regards, Tom Ogilvy "Chip Pearson" wrote in message ... v = Sheet1!MySeq Should be Sheet1.MySeq -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming | |||
Forms and Modules | Excel Programming | |||
Modules and Forms II | Excel Programming | |||
Modules and Forms | Excel Programming |