Selasa, 11 Desember 2012

Re: [ExcelVBA] Userform in excel 2010

 

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]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
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