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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
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