Can’t remember the code to use

[ipbr21054]

I have a specific cell which is J9

I have a spreadsheet of user information.

Now I cant remember the name of the code to use but when a name is entered into cell J9 this code would then look at the spreadsheet in column D for the same name & select its cell.

Thanks.

 

[ipbr21054]

Hi,
Thanks,did you try and entry in cell E1 something that isnt in column A ?
I just entered Tommy and i see the same error message.

Does it happen at your end ?

 

[MARK858]

No it doesn't error for me, do you seriously think I would have posted it without testing that it wasn't erring out?
But I did comment out all your other subs so if you have any other issues that I won't know about.

Btw, I just retested with Tommy and it didn't error.

And by the way it is E3 you are entering in not E1.

Are you sure that you reset your debugger and made sure that enableevents was set to true?

 

[ipbr21054]

I had to ask the question.

Yes E3 sorry my mistake.

I copied the code from above & pasted it.
Still errors out for me

enable events are all true

 

[ipbr21054]

Mark if you upload the file that doesn’t error out for you let me try it here.

 

[MARK858]

It is the same file that you uploaded just with all the code commented out and the code I posted added in.

 

[ipbr21054]

Well that explains the day I’ve had.
I can’t see why copying your code at 8:45 and pasting it chucks up the error message yet it didn’t error out for you.

 

[MARK858]

Just to make sure that your file matches mine the file is in the link below (and it is new one from your uploaded file).

https://app.box.com/s/e4udgf07nvc1fhfxkrrxnju7sf3mmt4k

 

[ipbr21054]

Well i dont know where to start.
Tried to open the file and was told its not a Dll file.

So i deleted it and downloaded again,this time when i try to open it it took for ages.
I see the cursor just going round and around,i then see my sheet.
I type say Dog in the cell E3 but then see an error message saying property not found.
When i debug it i see the Ucase code shown in yellow,i delete it then save & open the file again.now im told its already open.

So at present i havent been able to try and type in cell E3 yet

 

[MARK858]

Just downloaded it twice from the link and both opened fine for me.

 

[ipbr21054]

Ok
Totally lost.
That’s it now as I’m knackered.

Will look tomorrow.
Thanks for your help & I hope tomorrow will be better.