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.

 

[MARK858]

Try the link below

https://www.dropbox.com/s/jwex3rzddd4p62k/MARK858.xlsm?dl=0

 

[ipbr21054]

Just off out.
I downloaded the Dropbox file and it pretty much opened straight away.
When I see Tommy I typed Boo and hit enter. I was then show an error message where in the code the line about Ucase 6.1 etc was in yellow.
I deleted it quickly and saved the file no problem.
I then tried to open it again where a message said This is nit a Dll file ?

When I’m back later I will copy the code in this file to a working file on my pc.
Thanks for sorting out the Dropbox setup and trying to help. Much appreciated.

 

[MARK858]

Just so you are aware I get no error typing Boo in E3 and no DLL error (which I wouldn't expect to as it is the same file you uploaded) and this was the file in the link you just used.

 

[ipbr21054]

Yep I agree.
Very strange how the same file gives different issue at my end.
Will take a look later thanks.

 

[ipbr21054]

@MARK858
The only way to open this file like normal & without the cursor spinning around was to save it to drop box first,then download the zip file & extract it.
Double clicking on this file i then typed say ZZZ followed by hitting enter.
I now see a run time error 91, Object variable or With block variable not set.

If i copy the code from post # 20 & put into the file i get the same message.

I will pm you a private message of a drop box link.
This link will be a file including all the other tabs sheets.
Then hopefully we will sort this.

If you could add / edit the code with the working code you have & try it so its ok then zip it up & upload to drop box.

I will thendownlaod it.

 

[MARK858]

Afraid I don't really want to debug a mass of code on a Sunday (especially as there are a load of errors in the cells to sort through).

If I get bored during the week I might plow through it.

 

[ipbr21054]

I mean just put the code from the working file you have into my shet.
I will then try that.

Cany see why it works for you and not me.

 

[NoSparks]

@ ipbr21054

In the past you've said you don't like my suggestions to your issues and to not bother in the future.
So you're more than welcome to ignore this.

Mark's files from both box and dropbox download, open and operate fine for me.

from post 42

When I see Tommy I typed Boo and hit enter. I was then show an error message where in the code the line about Ucase 6.1 etc was in yellow.

Put a break point at the beginning of the Worksheet_Change procedure,
then when the code stops there, continue on by stepping through the code one line at a time using the F8 key to follow where the code goes.
Because Tommy or Boo aren't found in column A and therefore can't be selected, there is an error which takes the code to errHandle2,
the line about Ucase 6.1 etc which you say is giving an error and being highlighted yellow is never executed.

Makes me think you're not working with the file you think you are.

 

[ipbr21054]

I have downloaded the file from here https://www.dropbox.com/s/jwex3rzddd4p62k/MARK858.xlsm?dl=0

It downloads as MARK858
I double click on it and i see 2 tabs,DATABASE & INFO.
On the DATABASE tab i select cell E3 and type something random like Poppy & hit enter.
The error message i then see is as shown below.
This file MARK858 has most of the code in Green & the last part of the code is black as it should be.

With respect the break point.
I open the file & place my cursor on the code Worksheet_Change etc etc.
I then hit F9 where i then see a red marker through the text & a round marker to the left.
I type into cell E3 and hit enter,i now see the error message as shown below & the text Ucase$ is shown in blue.
I then click ok & press F8 but the same error message box keeps popping up and i do not move doen through the code.

 

[ipbr21054]

Ok
Now got it going,as first time using this.
Break point at start of Worksheet Change code.
Type into cell E3 hjh then hit enter.
The Worksheet Change code is shown in yellow and i press F8
I work through the code and now the arrow is on this code line Columns("A:A").Find(Target.Value, , , xlWhole, , xlNext).Select so i press F8
Then i see the error message 91, Object value or With block variable not set.