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>
To: ExcelVBA@yahoogroups.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@yahoogroups.com] On
Behalf Of Nishu Kumar
Sent: Tuesday, 14 February 2012 8:04 AM
To: ExcelVBA@yahoogroups.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]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 4

Visit Your Group

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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___