Kamis, 13 Desember 2012

Re: [ExcelVBA] Userform in excel 2010

 

Beverly,

The reason Lisa never saw an original post is because you responded to Lisa's
post regarding her "New Office 365 Yahoo Group" and simply changed the subject.
 
By doing that, instead of starting a discussion thread of your own, you are
making your question part of this Office 365 discussion.

This practice is called "Hijacking" a thread.

It also makes it difficult for someone to help.

For example, often when I prepare to respond to a question, I will go to the
forum and look through the discussions for the

thread.
I can then see other responses and make sure someone else hasn't already posted
a reply similar to my own.

By "hijacking" another discussion, your query will not show up in the list.
and.. what are the odds that I'd look for a question about a userform in
a discussion about Office 365?

To make it EASIER to start a new discussion topic, at the bottom of the post you
received in your email, there is a link that says "Start a New Topic ".

hope this helps (HTH)

Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------

________________________________
From: beverley sterling <beezsting@yahoo.com>
To: ExcelVBA@yahoogroups.com
Sent: Wed, December 12, 2012 11:38:39 PM
Subject: Re: [ExcelVBA] Userform in excel 2010

 
Hi,
Sorry, I was not aware that the email was sent, as I got emails stating that it
could not be sent.
I will revisit my codes and send another mail.
ThanksBeverley

--- On Tue, 12/11/12, 1z@compuserve.com <1z@compuserve.com> wrote:

From: 1z@compuserve.com <1z@compuserve.com>
Subject: Re: [ExcelVBA] Userform in excel 2010
To: ExcelVBA@yahoogroups.com
Received: Tuesday, December 11, 2012, 3:12 PM

 

Hey Beverly...

I can't find an "original" message for this... one without Re in front.

After reading your email though I'm assuming that you just forgot to remove that
before posting.

Daves' right... But ... if you want to be sure of sending an email with an OK
format ... one idea is to email it to yourself first!!

Then you're sure your email can be read.... :-)

HTH

Lisa

Sent: Tue, Dec 11, 2012 9:43 am

Subject: Re: [ExcelVBA] Userform in excel 2010

Your code has been quite corrupted by your e-mail. Once I insert returns

into it, I see four separate copies of the same 8 assignment statements.

There is also a small cmdOK_Click() sub.

You say it highlights "Me.txt", but that occurs many times in the code

you've posted. Exactly which one is it?

Also, it's odd that this is all that is highlighted. For instance, if I

copy the sub into a form and try the compilation (Excel 2003), the highlight

is on the line

If Me.txtFirstName.Value = "" Then

and covers ".txtFirstName".

If the highlight is stopping at the end of the ".txt", then it sounds as

though you might have a space after the ".txt" and before the remainder of

the name.

Have another go at copying your code, but make sure that your message is

plain text first. And also please indicate exactly which statement it

doesn't like.

Are you sure that you have text boxes named exactly as you have them in the

code? txtdate, txtname, txtMICostCenter, txtProjectName,

txtSuppliertocharge, txtResponsiblPerson, txtCostCenter, txthours,

txtFirstName

Note that you have txtname and also txtFirstName

Also note the misspelling in txtResponsiblPerson

Regards, Dave S

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar