Use Vlookup vba

[HaroonSid]

hello evryone

i want to create a userform.
with using userform i want to add some numbers according few conditions

e.g

i want to add some number to my table

NAME5 = COLUMN A = ADD = 6 Result should be in cell (c7)
NAME5 = COLUMN B = ADD = 5 Result should be in cell (d7)
NAME5 = COLUMN C = ADD = 2 Result should be in cell (e7)

I ATTACHED A SAMPLE FILE

PLZ SOLVE MY PROBLEM

[Bob Phillips]

Please Login or Register  to view this content.

[:) Sixthsense :)]

Do double click on Add button and paste the below code...

Please Login or Register  to view this content.

[HaroonSid]

Sixthsense

THANX A Lot

but there is a little problem

if i want to add a new name like "Name11" then

this one asked for to add or not
if
yes then add
if
no then no

and update the name list

plz do somthig

[HaroonSid]

thanx for reply Bob Phillips

sorry but not working

[:) Sixthsense :)]

Sorry I am unable to follow you...

Because I already provided code for add button.. and your Post #4 requirement seems to get conflict with my earlier suggestion.

Can you please show it in revised file with your expected task?

[HaroonSid]

dear Sixthsense
This code is working perfectly

in this code

Please Login or Register  to view this content.

In ComboBox1 if i add a name which is not in range "B:B" Then a form pop up and asked for "this name is not in range "B:B", do u want to add it in range "B:B"
if i click on yes
then
add it to range "B:B" and update the ComboBox1
if i click no
then don't add this to range "B:B"

[:) Sixthsense :)]

Replace the previous code with the below one

Please Login or Register  to view this content.

[HaroonSid]

wow..............
thats working very cool....

thanx a lot very very much

best regards
haroon2015