(Msg. 1) Posted: Thu Jul 10, 2008 4:26 pm
Post subject: Calculating Add to elertz Archived from groups: microsoft>public>word>vba>userforms (more info?)
I am working on a template that requires two seperate calculations.
One is for "starting cost" and the other "Ongoing Yearly Cost"
this calculation gets its value from two seperate frames.
If i do a if statement such as
if text.value <> "" Then
if text.value <> then......
if forces each textbox to have a value for it to calculate.
I am assuming that I need to do a seperate Loop function that will go
through both frames and see which textbox has a value for the starting cast
and which one has one for the Ongoing "
If someone can help me...I've been working on this all week and can't figure
it out. I was suppose to have done by 7/11/08.
I could send a copy of what I'm working on so that you could see what I mean.
(Msg. 2) Posted: Fri Jul 11, 2008 3:04 am
Post subject: Re: Calculating Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
What type of form is this? Where do the frames come into it? Send me a
copy of the template it you wish and I will take a look at it.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
news:1EA9A8D5-0172-41A6-B029-083F12ED67AB@microsoft.com...
>I am working on a template that requires two seperate calculations.
> One is for "starting cost" and the other "Ongoing Yearly Cost"
> this calculation gets its value from two seperate frames.
>
> If i do a if statement such as
> if text.value <> "" Then
> if text.value <> then......
> if forces each textbox to have a value for it to calculate.
>
> I am assuming that I need to do a seperate Loop function that will go
> through both frames and see which textbox has a value for the starting
> cast
> and which one has one for the Ongoing "
>
> If someone can help me...I've been working on this all week and can't
> figure
> it out. I was suppose to have done by 7/11/08.
>
> I could send a copy of what I'm working on so that you could see what I
> mean.
>
>
>
(Msg. 3) Posted: Fri Jul 11, 2008 3:04 am
Post subject: Re: Calculating Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Doug, I tried sending you a copy around 6:30 pacific, but was returned to
mea, I tried again around 10:47pm
Please, if you don't get my email, let know what other should I send you a
copy of the template.
Thank you
"Doug Robbins - Word MVP" wrote:
> What type of form is this? Where do the frames come into it? Send me a
> copy of the template it you wish and I will take a look at it.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "aenico" <aenico DeleteThis @discussions.microsoft.com> wrote in message
> news:1EA9A8D5-0172-41A6-B029-083F12ED67AB@microsoft.com...
> >I am working on a template that requires two seperate calculations.
> > One is for "starting cost" and the other "Ongoing Yearly Cost"
> > this calculation gets its value from two seperate frames.
> >
> > If i do a if statement such as
> > if text.value <> "" Then
> > if text.value <> then......
> > if forces each textbox to have a value for it to calculate.
> >
> > I am assuming that I need to do a seperate Loop function that will go
> > through both frames and see which textbox has a value for the starting
> > cast
> > and which one has one for the Ongoing "
> >
> > If someone can help me...I've been working on this all week and can't
> > figure
> > it out. I was suppose to have done by 7/11/08.
> >
> > I could send a copy of what I'm working on so that you could see what I
> > mean.
> >
> >
> >
>
>
>
(Msg. 4) Posted: Fri Jul 11, 2008 6:40 pm
Post subject: Re: Calculating Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
To where did you send it. You have to remove the obvious from my email
address dkr.TakeThisOut@REMOVECAPSmvps.org
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
news:4D916F38-9DF6-401D-B3BE-1CDD11818147@microsoft.com...
> Hi Doug, I tried sending you a copy around 6:30 pacific, but was returned
> to
> mea, I tried again around 10:47pm
> Please, if you don't get my email, let know what other should I send you a
> copy of the template.
>
> Thank you
>
> "Doug Robbins - Word MVP" wrote:
>
>> What type of form is this? Where do the frames come into it? Send me a
>> copy of the template it you wish and I will take a look at it.
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:1EA9A8D5-0172-41A6-B029-083F12ED67AB@microsoft.com...
>> >I am working on a template that requires two seperate calculations.
>> > One is for "starting cost" and the other "Ongoing Yearly Cost"
>> > this calculation gets its value from two seperate frames.
>> >
>> > If i do a if statement such as
>> > if text.value <> "" Then
>> > if text.value <> then......
>> > if forces each textbox to have a value for it to calculate.
>> >
>> > I am assuming that I need to do a seperate Loop function that will go
>> > through both frames and see which textbox has a value for the starting
>> > cast
>> > and which one has one for the Ongoing "
>> >
>> > If someone can help me...I've been working on this all week and can't
>> > figure
>> > it out. I was suppose to have done by 7/11/08.
>> >
>> > I could send a copy of what I'm working on so that you could see what I
>> > mean.
>> >
>> >
>> >
>>
>>
>>
(Msg. 5) Posted: Fri Jul 11, 2008 6:40 pm
Post subject: Re: Calculating Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hello, I resent it. Sorry, I just copied and pasted .... was in a hurry.
"Doug Robbins - Word MVP" wrote:
> To where did you send it. You have to remove the obvious from my email
> address dkr RemoveThis @REMOVECAPSmvps.org
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "aenico" <aenico RemoveThis @discussions.microsoft.com> wrote in message
> news:4D916F38-9DF6-401D-B3BE-1CDD11818147@microsoft.com...
> > Hi Doug, I tried sending you a copy around 6:30 pacific, but was returned
> > to
> > mea, I tried again around 10:47pm
> > Please, if you don't get my email, let know what other should I send you a
> > copy of the template.
> >
> > Thank you
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> What type of form is this? Where do the frames come into it? Send me a
> >> copy of the template it you wish and I will take a look at it.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Please reply to the newsgroup unless you wish to avail yourself of my
> >> services on a paid consulting basis.
> >>
> >> Doug Robbins - Word MVP
> >>
> >> "aenico" <aenico RemoveThis @discussions.microsoft.com> wrote in message
> >> news:1EA9A8D5-0172-41A6-B029-083F12ED67AB@microsoft.com...
> >> >I am working on a template that requires two seperate calculations.
> >> > One is for "starting cost" and the other "Ongoing Yearly Cost"
> >> > this calculation gets its value from two seperate frames.
> >> >
> >> > If i do a if statement such as
> >> > if text.value <> "" Then
> >> > if text.value <> then......
> >> > if forces each textbox to have a value for it to calculate.
> >> >
> >> > I am assuming that I need to do a seperate Loop function that will go
> >> > through both frames and see which textbox has a value for the starting
> >> > cast
> >> > and which one has one for the Ongoing "
> >> >
> >> > If someone can help me...I've been working on this all week and can't
> >> > figure
> >> > it out. I was suppose to have done by 7/11/08.
> >> >
> >> > I could send a copy of what I'm working on so that you could see what I
> >> > mean.
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>
(Msg. 6) Posted: Sat Jul 12, 2008 3:04 am
Post subject: Re: Calculating Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I have not received it.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
news:7612FFC8-5620-488F-A2D1-D360F430BDAC@microsoft.com...
> Hello, I resent it. Sorry, I just copied and pasted .... was in a hurry.
>
> "Doug Robbins - Word MVP" wrote:
>
>> To where did you send it. You have to remove the obvious from my email
>> address dkr.TakeThisOut@REMOVECAPSmvps.org
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:4D916F38-9DF6-401D-B3BE-1CDD11818147@microsoft.com...
>> > Hi Doug, I tried sending you a copy around 6:30 pacific, but was
>> > returned
>> > to
>> > mea, I tried again around 10:47pm
>> > Please, if you don't get my email, let know what other should I send
>> > you a
>> > copy of the template.
>> >
>> > Thank you
>> >
>> > "Doug Robbins - Word MVP" wrote:
>> >
>> >> What type of form is this? Where do the frames come into it? Send me
>> >> a
>> >> copy of the template it you wish and I will take a look at it.
>> >>
>> >> --
>> >> Hope this helps.
>> >>
>> >> Please reply to the newsgroup unless you wish to avail yourself of my
>> >> services on a paid consulting basis.
>> >>
>> >> Doug Robbins - Word MVP
>> >>
>> >> "aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
>> >> news:1EA9A8D5-0172-41A6-B029-083F12ED67AB@microsoft.com...
>> >> >I am working on a template that requires two seperate calculations.
>> >> > One is for "starting cost" and the other "Ongoing Yearly Cost"
>> >> > this calculation gets its value from two seperate frames.
>> >> >
>> >> > If i do a if statement such as
>> >> > if text.value <> "" Then
>> >> > if text.value <> then......
>> >> > if forces each textbox to have a value for it to calculate.
>> >> >
>> >> > I am assuming that I need to do a seperate Loop function that will
>> >> > go
>> >> > through both frames and see which textbox has a value for the
>> >> > starting
>> >> > cast
>> >> > and which one has one for the Ongoing "
>> >> >
>> >> > If someone can help me...I've been working on this all week and
>> >> > can't
>> >> > figure
>> >> > it out. I was suppose to have done by 7/11/08.
>> >> >
>> >> > I could send a copy of what I'm working on so that you could see
>> >> > what I
>> >> > mean.
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>
(Msg. 7) Posted: Sat Jul 12, 2008 3:04 am
Post subject: Re: Calculating Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi aenico,
If this is a document using formfields, you may not need vba at all. What is it you are trying to do?
--
Cheers
macropod
[MVP - Microsoft Word]
"aenico" <aenico RemoveThis @discussions.microsoft.com> wrote in message news:1EA9A8D5-0172-41A6-B029-083F12ED67AB@microsoft.com...
>I am working on a template that requires two seperate calculations.
> One is for "starting cost" and the other "Ongoing Yearly Cost"
> this calculation gets its value from two seperate frames.
>
> If i do a if statement such as
> if text.value <> "" Then
> if text.value <> then......
> if forces each textbox to have a value for it to calculate.
>
> I am assuming that I need to do a seperate Loop function that will go
> through both frames and see which textbox has a value for the starting cast
> and which one has one for the Ongoing "
>
> If someone can help me...I've been working on this all week and can't figure
> it out. I was suppose to have done by 7/11/08.
>
> I could send a copy of what I'm working on so that you could see what I mean.
>
>
>
(Msg. 8) Posted: Sat Jul 12, 2008 3:04 am
Post subject: Re: Calculating Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Doug,
I have once again resent it to you. it is 2:43pm.
"Doug Robbins - Word MVP" wrote:
> I have not received it.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
> news:7612FFC8-5620-488F-A2D1-D360F430BDAC@microsoft.com...
> > Hello, I resent it. Sorry, I just copied and pasted .... was in a hurry.
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> To where did you send it. You have to remove the obvious from my email
> >> address dkr.TakeThisOut@REMOVECAPSmvps.org
> >>
> >> --
> >> Hope this helps.
> >>
> >> Please reply to the newsgroup unless you wish to avail yourself of my
> >> services on a paid consulting basis.
> >>
> >> Doug Robbins - Word MVP
> >>
> >> "aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
> >> news:4D916F38-9DF6-401D-B3BE-1CDD11818147@microsoft.com...
> >> > Hi Doug, I tried sending you a copy around 6:30 pacific, but was
> >> > returned
> >> > to
> >> > mea, I tried again around 10:47pm
> >> > Please, if you don't get my email, let know what other should I send
> >> > you a
> >> > copy of the template.
> >> >
> >> > Thank you
> >> >
> >> > "Doug Robbins - Word MVP" wrote:
> >> >
> >> >> What type of form is this? Where do the frames come into it? Send me
> >> >> a
> >> >> copy of the template it you wish and I will take a look at it.
> >> >>
> >> >> --
> >> >> Hope this helps.
> >> >>
> >> >> Please reply to the newsgroup unless you wish to avail yourself of my
> >> >> services on a paid consulting basis.
> >> >>
> >> >> Doug Robbins - Word MVP
> >> >>
> >> >> "aenico" <aenico.TakeThisOut@discussions.microsoft.com> wrote in message
> >> >> news:1EA9A8D5-0172-41A6-B029-083F12ED67AB@microsoft.com...
> >> >> >I am working on a template that requires two seperate calculations.
> >> >> > One is for "starting cost" and the other "Ongoing Yearly Cost"
> >> >> > this calculation gets its value from two seperate frames.
> >> >> >
> >> >> > If i do a if statement such as
> >> >> > if text.value <> "" Then
> >> >> > if text.value <> then......
> >> >> > if forces each textbox to have a value for it to calculate.
> >> >> >
> >> >> > I am assuming that I need to do a seperate Loop function that will
> >> >> > go
> >> >> > through both frames and see which textbox has a value for the
> >> >> > starting
> >> >> > cast
> >> >> > and which one has one for the Ongoing "
> >> >> >
> >> >> > If someone can help me...I've been working on this all week and
> >> >> > can't
> >> >> > figure
> >> >> > it out. I was suppose to have done by 7/11/08.
> >> >> >
> >> >> > I could send a copy of what I'm working on so that you could see
> >> >> > what I
> >> >> > mean.
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office