Can’t remember the code to use

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,199
Office Version
  1. 2007
Platform
  1. Windows
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.
 
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 ?
 
Upvote 0

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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?
 
Last edited:
Upvote 0
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
 
Upvote 0
Mark if you upload the file that doesn’t error out for you let me try it here.
 
Upvote 0
It is the same file that you uploaded just with all the code commented out and the code I posted added in.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
Just downloaded it twice from the link and both opened fine for me.
 
Upvote 0
Ok
Totally lost.
That’s it now as I’m knackered.

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

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top