Rabu, 15 Februari 2012

RE: [ExcelVBA] enable event

 

The Yahoo Group has automatically stripped off your attachment. You
need to explain in your e-mail or upload a file to the files area.


Regards, Dave S

________________________________

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Nishu Kumar
Sent: Wednesday, 15 February 2012 10:22
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] enable event

Hi sir,

Please accept my sincere apologies as i was not able enough to explain
my query. Please find attached sheet where column A consist associate
name and column b consist their unique system id (provided by the
organization). All i want is the coding/procedure/name of the variable,
event name etc. which help me to populate the system id automatically in
the column b assuming that column b is blanked and i am mentioning the
associate name in column A one by one.

Kindly assist on this.

Thanks & Regards,
Nishu

________________________________
From: Paul Vermeulen <paul.vermeulen@vulcantech.com.au
<mailto:paul.vermeulen%40vulcantech.com.au> >
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
Sent: Tuesday, 14 February 2012 8:59 AM
Subject: RE: [ExcelVBA] enable event

Nishu

You are not describing the problem clearly enough for someone to give
you guidance on how to solve it yourself. How exactly to you want to
generate the unique employee id? Assuming you type in a name and first
letter of surname in column a, do you want random characters as a
suffix? Do you want sequential characters as a suffix? How about
starting with numeric rather than text characters? Let us know, please.

From: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
[mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ]
On
Behalf Of Nishu Kumar
Sent: Tuesday, 14 February 2012 8:04 AM
To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
Subject: [ExcelVBA] enable event

Hi Group,

How you doing!!

Hope this mail finds you doing well.

I am trying to enable a column b in excel with unique employee ids.
please suggest me the coding as what needs to be done to get the
respective team member ids get populated when name mention in column a.

e.g.

column Acolumn b
johnyasdfi (should come automatically, when i mention the name in column
A)
danissonijklm (should come automatically, when i mention the name in
column A)

Kindly suggest.

Thanks & Regards,
Nishu

[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]

----------

Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.

UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.

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

__._,_.___
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