Checking row for duplicates, and also accepting integers and get the "B" + int value

**Sydstar** · 10-31-2014, 02:01 AM

hello guys,

I'm currently working on a piece of code that looks like this

Please Login or Register  to view this content.

So as it is now when i insert a duplicate value in row C and only row C; it gives me a message and clears out the cell

I would like for it to also accept an integer from 1-1000 and then it should fetch the value out of another excel file in cell ' B + given integer' AGAIN only in row C

any thoughts ?

thx

**millz** · 10-31-2014, 02:34 AM

How about this? I don't really like the idea of using a loop, so I changed that.

Please Login or Register  to view this content.

**Sydstar** · 10-31-2014, 03:58 AM

Thx for the reply, when you enter an integer it also should look for duplicate names associated with the reference since you have the duplicate search in the else i don't think this applies; also i don't know how to extract the information in a different excel file (not different sheet) with this kind of structure

Please Login or Register  to view this content.

I can't test the code before i have this last part down; do i make an absolute path or what?
thx for the help !

**Sydstar** · 10-31-2014, 04:47 AM

bump no response

**millz** · 10-31-2014, 05:37 AM

Originally Posted by Sydstar

bump no response

Really? You took 1 hour and 24 minutes to respond to my post, but post a 'bump no response' after only 49 minutes? In case you're wondering, most helpers (I don't want to entirely exclude the possibility of aliens) on this forum are just normal humans, like yourself, possibly holding a full time job, as well as are packed with any other schedules in life. Don't expect instant responses please.

Originally Posted by Sydstar

when you enter an integer it also should look for duplicate names associated with the reference

You didn't mention that before....

Originally Posted by Sydstar

i don't know how to extract the information in a different excel file (not different sheet) with this kind of structure

My bad on this, I assumed you would know how to do that. Below additional code should handle all that now. Set your file path and sheet name accordingly.

Please Login or Register  to view this content.

**Sydstar** · 10-31-2014, 05:44 AM

I'm sorry mate, I didn't mean no disrespect I didn't expect you'd be answering again, but someone new(btw it's the first thread that gets a response from anyone.. thank you for that). i don't know the tendencies of the forum; i just started programming vba from scratch this week i have a lot of holes in knowledge.

I have solved the code for what i want but noticed that this code only works if the name or integer gets inserted AFTER the row with the duplicate name.

for example if jan has been inserted in row 20 and i insert jan in row 10 it doesn't give the message

I'll wait now :p
thx in advance

Please Login or Register  to view this content.

I should note that this works because i have a commandbutton that already opens the workbook in question next to the active worksheet. and is expected to be open every time a name get's inserted using the integer method

**Sydstar** · 10-31-2014, 06:00 AM

nevermind I understand your code now and 'fixed it '

Please Login or Register  to view this content.

would you change anything about this code ? like the way you make the integer system work; is that better ? or doesn't it matter

thx for the feedback

**millz** · 10-31-2014, 06:08 AM

Edit: Made changes

Please Login or Register  to view this content.

**Sydstar** · 10-31-2014, 07:09 AM

ok thx for the help both codes work; now i tried what happened if i didn't open de HR-LIJST.xlsm and an error occured; but after that; i wasn't able to run the code even if the HR-lijst was open.
nor did it filter the entire names. it looks like the entire code stops working then; i tried the reset button in vba but it doesn't work. only thing that works is reopening the entire excel file..

grtz,
sydney

**millz** · 10-31-2014, 10:54 AM

That's probably because the events are not started back after error occurred.

Please Login or Register  to view this content.

Now in your VBA editor window, press Ctrl + G to bring up the immediate window (should appear somewhere on the bottom). Type in Application.EnableEvents = True and press Enter.

Checking row for duplicates, and also accepting integers and get the "B" + int value

LinkBack

Thread Tools

Rate This Thread

Display

Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Re: Checking row for duplicates, and also accepting integers and get the "B" + int value

Thread Information

Users Browsing this Thread

Similar Threads

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

Make a list of integers from 0, 1, 2..."n" where "n" is specified in another cell.

"Locking" Cell OR Accepting User Input based on the value of another cell's dropdown menu.

[SOLVED] Conditional formatting to highlight duplicates based on "Yes" or "No" in another column

[SOLVED] Continually accepting the "User Agreement".

Bookmarks

Bookmarks

Posting Permissions