InputBox Query

Hi
I have an inputbox which stores the message in stMessage.

stMessage has bee put as a public sub so we can use the stMessage in other
sub's.

I have a cmd button which checks that all details are entered prior to
emailing the spreadsheet and if something is missing a msgbox appears
advising the user to enter information.

When this happens, the stMessage is wiped clean and we lose the message.

Is there a way to make sure that the stMessage doesn't change unless advised
to do so.

Thanks
Noemi

Sounds like you are using stMessage to store the answer from the second
message box you talk about, as well as the original inputbox. Just use
another variable for that message box.

Jeff

"Noemi" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I have an inputbox which stores the message in stMessage.
>
> stMessage has bee put as a public sub so we can use the stMessage in other
> sub's.
>
> I have a cmd button which checks that all details are entered prior to
> emailing the spreadsheet and if something is missing a msgbox appears
> advising the user to enter information.
>
> When this happens, the stMessage is wiped clean and we lose the message.
>
> Is there a way to make sure that the stMessage doesn't change unless
> advised
> to do so.
>
> Thanks
> Noemi

Hi Jeff
I tried it but the stMessage stl goes to nothing once the program ends due
to missing data needs to be entered.

Is there a way to store the information in the stMessage so even if the
program ends (due to having to enter additional information) we dont lose the
comments entered previously.

Thanks
Noemi

"Jeff Standen" wrote:

> Sounds like you are using stMessage to store the answer from the second
> message box you talk about, as well as the original inputbox. Just use
> another variable for that message box.
>
> Jeff
>
> "Noemi" <[email protected]> wrote in message
> news:[email protected]...
> > Hi
> > I have an inputbox which stores the message in stMessage.
> >
> > stMessage has bee put as a public sub so we can use the stMessage in other
> > sub's.
> >
> > I have a cmd button which checks that all details are entered prior to
> > emailing the spreadsheet and if something is missing a msgbox appears
> > advising the user to enter information.
> >
> > When this happens, the stMessage is wiped clean and we lose the message.
> >
> > Is there a way to make sure that the stMessage doesn't change unless
> > advised
> > to do so.
> >
> > Thanks
> > Noemi
>
>
>

Ah, sorry, misunderstood your question. Variables disappear from memory when
the program finishes, so you need to store the information somewhere. I
would use a hidden Name, since that is kept even when the workbook is
closed. You can then fetch it from there when you need to.

Jeff


"Noemi" <[email protected]> wrote in message
news:[email protected]...
> Hi Jeff
> I tried it but the stMessage stl goes to nothing once the program ends due
> to missing data needs to be entered.
>
> Is there a way to store the information in the stMessage so even if the
> program ends (due to having to enter additional information) we dont lose
> the
> comments entered previously.
>
> Thanks
> Noemi
>
> "Jeff Standen" wrote:
>
>> Sounds like you are using stMessage to store the answer from the second
>> message box you talk about, as well as the original inputbox. Just use
>> another variable for that message box.
>>
>> Jeff
>>
>> "Noemi" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hi
>> > I have an inputbox which stores the message in stMessage.
>> >
>> > stMessage has bee put as a public sub so we can use the stMessage in
>> > other
>> > sub's.
>> >
>> > I have a cmd button which checks that all details are entered prior to
>> > emailing the spreadsheet and if something is missing a msgbox appears
>> > advising the user to enter information.
>> >
>> > When this happens, the stMessage is wiped clean and we lose the
>> > message.
>> >
>> > Is there a way to make sure that the stMessage doesn't change unless
>> > advised
>> > to do so.
>> >
>> > Thanks
>> > Noemi
>>
>>
>>

Ah, sorry, misunderstood your question. Variables disappear from memory when
the program finishes, so you need to store the information somewhere. I
would use a hidden Name, since that is kept even when the workbook is
closed. You can then fetch it from there when you need to.

Jeff


"Noemi" <[email protected]> wrote in message
news:[email protected]...
> Hi Jeff
> I tried it but the stMessage stl goes to nothing once the program ends due
> to missing data needs to be entered.
>
> Is there a way to store the information in the stMessage so even if the
> program ends (due to having to enter additional information) we dont lose
> the
> comments entered previously.
>
> Thanks
> Noemi
>
> "Jeff Standen" wrote:
>
>> Sounds like you are using stMessage to store the answer from the second
>> message box you talk about, as well as the original inputbox. Just use
>> another variable for that message box.
>>
>> Jeff
>>
>> "Noemi" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hi
>> > I have an inputbox which stores the message in stMessage.
>> >
>> > stMessage has bee put as a public sub so we can use the stMessage in
>> > other
>> > sub's.
>> >
>> > I have a cmd button which checks that all details are entered prior to
>> > emailing the spreadsheet and if something is missing a msgbox appears
>> > advising the user to enter information.
>> >
>> > When this happens, the stMessage is wiped clean and we lose the
>> > message.
>> >
>> > Is there a way to make sure that the stMessage doesn't change unless
>> > advised
>> > to do so.
>> >
>> > Thanks
>> > Noemi
>>
>>
>>

Hi Jeff
I dont understand what you mean by hidden Name.
Can you please clarify for me.
Thanks
Noemi

"Jeff Standen" wrote:

> Ah, sorry, misunderstood your question. Variables disappear from memory when
> the program finishes, so you need to store the information somewhere. I
> would use a hidden Name, since that is kept even when the workbook is
> closed. You can then fetch it from there when you need to.
>
> Jeff
>
>
> "Noemi" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Jeff
> > I tried it but the stMessage stl goes to nothing once the program ends due
> > to missing data needs to be entered.
> >
> > Is there a way to store the information in the stMessage so even if the
> > program ends (due to having to enter additional information) we dont lose
> > the
> > comments entered previously.
> >
> > Thanks
> > Noemi
> >
> > "Jeff Standen" wrote:
> >
> >> Sounds like you are using stMessage to store the answer from the second
> >> message box you talk about, as well as the original inputbox. Just use
> >> another variable for that message box.
> >>
> >> Jeff
> >>
> >> "Noemi" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Hi
> >> > I have an inputbox which stores the message in stMessage.
> >> >
> >> > stMessage has bee put as a public sub so we can use the stMessage in
> >> > other
> >> > sub's.
> >> >
> >> > I have a cmd button which checks that all details are entered prior to
> >> > emailing the spreadsheet and if something is missing a msgbox appears
> >> > advising the user to enter information.
> >> >
> >> > When this happens, the stMessage is wiped clean and we lose the
> >> > message.
> >> >
> >> > Is there a way to make sure that the stMessage doesn't change unless
> >> > advised
> >> > to do so.
> >> >
> >> > Thanks
> >> > Noemi
> >>
> >>
> >>
>
>
>