LinkBack URL
About LinkBacks
Hi All,
I have written code to find matching value cell with my active cell using a search button. However it doesn't work.
My code is
Please Login or Register to view this content.
Code to find value in other worksheet in same workbook match with active cell
Hi All,
I have written code to find matching value cell with my active cell using a search button. However it doesn't work.
My code is
Please Login or Register to view this content.
Last edited by diyVBA; 12-20-2019 at 02:06 PM.
Is it because you're referring to two different worksheets?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I corrected it, I get a new error now for the same line:
Error 1004
Application-defined or object defined error
Is it "Production Item" or "Production List" to go to ?
- Battle without fear gives no glory - Just try
What is the new code ?I corrected it,
check the main code again
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
attached,the copy (book1)
The code is OK else the loop uses fCell which is never refreshed !!
how can i fix it? why does it throw error 1004 in Application.goto statement?
Using
means you want to use the cell with name "firstAdd"Please Login or Register to view this content.
There is no such cell in the sheet
Se to use
but still the comment concerning the loop !!!Please Login or Register to view this content.
how can i code it better, I am absolutely new with VBA. I want the person using Sched List worksheet to be able to find the record any number of times they want.
I actually just want the code to find the first match it finds and get out of the loop.
Is that means the record can exist several times in sheet "Production List" and you want to display all records ???to be able to find the record any number of times they want.
I actually just want the code to find the first match it finds and get out of the loop. The search should re-new when they change the active cell.
I want to find the first match and get out of the loop. When I change active cell it should renew the search!
So you do not need the loop
The code will be launched again when clicking the button
I changed it Application.Goto Reference:=Worksheets("Production List").Range(firstAdd)
it still doesn't work.
I removed the loop too, still doesn't work.
Please Login or Register to view this content.
I am basically trying to create a find functionality with the search button and active cell.
With next code
if you select in sheet "Sched List" cell "B5"
If you clic you are selecting in sheet "Production List" cell "D2"
You can come back to sheet "Sched List" and make another run ..!
Is it what you want ??
Please Login or Register to view this content.
Application.GoTo will jump to the cell specified, not return a value. Is that what you want?
Please explain the process that you want to implement, NOT what you think the code does (or you think it should do).
It sounds as though you need a Worksheet Change Event handler and, possibly, Application.WorksheetFunction.VLookup to return one or more values.
If your code DID work, it looks as though you would enter a value in a cell, press a button, and that would jump to a matching cell on another sheet.
This is exactly what I want :
Enter a value in a cell, press a button, and that would jump to a matching cell on another sheet.
But my code isnt doing that. It just stays on the same active cell in Sched List worksheet.
this worked beautifullyOriginally Posted by pci
with next code
if you select in sheet "sched list" cell "b5"
if you clic you are selecting in sheet "production list" cell "d2"
you can come back to sheet "sched list" and make another run ..!
Is it what you want ??
Please Login or Register to view this content.
Houfff...good news
Happy Christmas with Excel ...!
This does what you want, I just don't really understand why you want to do it.
Please Login or Register to view this content.
Do you know that you could use the DoubleClick option instead of the button: See file attached
With next code just double click on cells in column "B" in sheet "Sched List"
Sheet "Sched List" 's code
In a modulePlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks