- Visual Basic.NET
- Microsoft Office
- Microsoft Access
- Microsoft Excel
- Visual Basic Classic
excel workbook search forms not working on home pc
i need to add 2 additional features to the search form in the excel workbook but when it opens on my home pc it produces error msgs & will not work.
At work, it works perfectly.
Could you please change the code so it works for me at home also. I have excel 2016 at work & at home.
zSearch-form_shape.xlsm
At work, it works perfectly.
Could you please change the code so it works for me at home also. I have excel 2016 at work & at home.
zSearch-form_shape.xlsm
If you have the same setup at home as you have at work, I would close my home Excel and reopen and if that doesn't fix the problem then reboot.
It looks to me like you are not using the same workbook in both places. A few weeks ago I supplied you with a workbook that will work in 64-bit, but the one you attached here still refers to tvFound which is a treeview control, and treeview controls are not supported in 64-bit.
You must have brought home the wrong workbook because the workbook you posted will not run in 64-bit.
All I can say is that the workbook that you posted can not work on 64-bit - ever. Compare the sizes of the two workbooks; I'm guessing that the sizes are not the same.
Here's another way you can verify that. Upload the workbook you attached in this post and try to run it at work. I bet it won't work.
i use excel 2016 on both work pc & at home, so i just dont get it...it must be something else thats causing this to happen, but thankyou nonetheless.
hi martin, it works for me at my work place, just at home it does not work
- i just wanted a modification on the form so that when it shows the results, i can click onto 1 of the results & it then brings me to my selected item on the excel sheet.
- can this be done?
- i just wanted a modification on the form so that when it shows the results, i can click onto 1 of the results & it then brings me to my selected item on the excel sheet.
- can this be done?
Frank, I can only repeat myself and say that the workbook you attached in this post can not possibly be the one that works for you at work. That's because it refers to an object called tvFound which is a Treeview control which 1) no longer exists in that workbook, and 2) even if it did, Treeview controls are not supported in your version of Excel.
ok i dont mean to cause you any frustration, my apologies
- i have attached the excel workbook that i use each day at work, could you add this feature described in my previous msg to the search form?
zSearch-form_shape_20.02.01.xlsm
- i have attached the excel workbook that i use each day at work, could you add this feature described in my previous msg to the search form?
zSearch-form_shape_20.02.01.xlsm
In this picture that I've artificially colored, which of the items when clicked, would you like to bring you to your selected item on the excel sheet? The green ones? The Yellow ones? Or both?![2020-01-31_14-59-06.png]()
how can both be done? i would have thought only 1 could be done..
- also is there a way to open the last search criteria?
- also is there a way to open the last search criteria?
I guess I wasn't clear so let me ask in another way.
If you clicked on the item indicted by the yellow arrow would you expect to be taken to cell A43 on the data sheet?
If you clicked on the item indicted by the green arrow would you expect to be taken to cell A43 on the data sheet?
![2020-01-31_14-59-06--1-.png]()
If you clicked on the item indicted by the yellow arrow would you expect to be taken to cell A43 on the data sheet?
If you clicked on the item indicted by the green arrow would you expect to be taken to cell A43 on the data sheet?
hi martin,
- i cant open your attached work sheet because i get a series of errors, compile error & so on....
- yes i would only click on the item idicated by the green arrow and yes i would want to be taken to cell 'a43' of the data sheet.
- also, when i open the search form i would like to be able to open the last search criteria if possible.
- i cant open your attached work sheet because i get a series of errors, compile error & so on....
- yes i would only click on the item idicated by the green arrow and yes i would want to be taken to cell 'a43' of the data sheet.
- also, when i open the search form i would like to be able to open the last search criteria if possible.
The attached workbook is a copy of the workbook you uploaded here. I changed the name to "xyz.xlsm" to avoid confusion. Please open it and let me know what happens.
xyz.xlsm
xyz.xlsm
Absolutely all I did was to rename the workbook that YOU downloaded. In other words I did not change it. This to me is proof that you are downloading the wrong workbook. Do you agree?
im confused the workbook i use every day at work is the one i sent you last, it just doesnt work for me on my home pc.
im confused the workbook i use every day at work is the one i sent you last,If your environment at work is 64-bit, then that workbook can not work there. If you read the error message you got running my xyz workbook, you'll see that it's telling you that it needs to be updated to 64-bit. Since I didn't change anything in the workbook you downloaded except to rename it xyz.xlsm, that workbook can not be your work workbook.
hi martin, i have just checked my email that i sent from work to home & this is the worksheet I use at work.
- please retry this one
zSearch-form_shape--1-.xlsm
- please retry this one
zSearch-form_shape--1-.xlsm
You need to remove the password. Also and I noticed this before, the workbook name ends in .xlsm.doc (as if it's a Word file) rather than just .xlsm
I'm sorry but that can't be it since it still has this
I don't know how your company works but can you verify with someone that you are selecting the correct production workbook? Also, if that's the production workbook, shouldn't it have a more normal name?
Option Explicit
Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwnd As Long) As Long
I don't know how your company works but can you verify with someone that you are selecting the correct production workbook? Also, if that's the production workbook, shouldn't it have a more normal name?
i can fwd you the email i sent myself from my work to my home so you can see..
- it is the correct production workbook, i renamed it because it was originally the one you created for me for my previous work.
- check if this one works for you..
zSearch-Form---Master-1.1.xlsm
- it is the correct production workbook, i renamed it because it was originally the one you created for me for my previous work.
- check if this one works for you..
zSearch-Form---Master-1.1.xlsm
Again it's calling for a password. It would be easier if you just sent me the password in an EE message. Only you and I can see that message.
Well that workbook no longer has the treeview object and that's good. Since I'm already working on a high-priority problem for someone else and since this workbooks search code is very different from the code in the 29170684.xlsm workbook that I attached above it may take me a few days to update it. Hopefully I can get it done by Thursday.
ok, so that im clear then this last one i sent you...what does the search form look like & how are the results shown? seems like its very different from the one i use now, as you say this last one has no treeview?
now your xyz.xlms file you posted yesterday does not work for me here at work either, see following error msg.
![compile error-1]()
The only workbook that you should care about now is zSearch-Form---Master-64-bit.xlsm. Please let me know if zSearch-Form---Master-64-bit.xlsm works in both places.
i am at home now and your file zSearch-Form---Master-64-b
![object not available - msg 1]()
I'm sorry but this time I attached the wrong workbook and I can't seem to find the right one. In one of our threads I think you said "this works at home". Do you know which workbook that was?
this one works for me at work, but not properly when i hit 'clear' in the form it will not clear any of the search criteria i have entered...
im at work now so i cant check to see if this works at home until this evening
im at work now so i cant check to see if this works at home until this evening
This workbook is the same code as 84bit.xlsm except that
- It now contains all the sheets
- The 'Clear' button works
- Clicking any node in the search results will take you to the row for that result
- Pressing 'Return' in any of the 3 search form textboxes will perform the search without having to click the 'Search' button.
hi martin, im now home and this workbook works, finally!
- once im at work tomorrow i will check it works there too.
- a question, if i add, edit or delete an item in this wksht while at home, then bring to work, will i have any problems?
- so why does this now work and all this time it has not?
- only thing is it possible to add the 'open last search' feature into the form?
- once im at work tomorrow i will check it works there too.
- a question, if i add, edit or delete an item in this wksht while at home, then bring to work, will i have any problems?
- so why does this now work and all this time it has not?
- only thing is it possible to add the 'open last search' feature into the form?
- a question, if i add, edit or delete an item in this wksht while at home, then bring to work, will i have any problems?If you mean that, say, you delete or change the data in the workbook and then you replace your work workbook with the one you just changed, then no, you won't have any problems.
- so why does this now work and all this time it has not?Two reasons: 1) we were working with the wrong workbook much of the time, and 2) I don't have 640bit so I could not test my changes.
- only thing is it possible to add the 'open last search' feature into the form?Please ask a new question.
hi martin, just got to work & tested your file above "29170684a.xlsm" and it also works here, thank god!
ill ask a new question for the additional feature, as you requested..
ill ask a new question for the additional feature, as you requested..
-
![]()
received a Solution
Same code working in Excel module but not in Access. -
![]()
wrote an Article
![]()
A Game of Draw Poker
-
![]()
created a Video
![]()
How to replace or substitute data in Excel
-
Explore Cloud Class® ![]()
Microsoft Office Excel 2019: Part 01
Premium Content
You need an Expert Office subscription to comment.Start Free Trial