excel workbook search forms not working on home pc

A password is being asked for.

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.

sorry experts, pwd removed & workbook re-attached
zSearch-form_shape.xlsm

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.

i use this workbook at work every day, but today i brought it at home & does not work.

You must have brought home the wrong workbook because the workbook you posted will not run in 64-bit.

no, i only have the 1 workbook i use at work & its this one, i have rechecked.

Here is the correct workbook.
Frank.xlsm

no, this workbook you have posted contains errors - see below[embed=file

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.

ok ill try that when im at work & let you know.

ok ill try that when im at work & let you know.

Any results?

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?

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

The workbook is asking for a password.

sorry martin, i have removed
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?

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?

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?

Try this.
29170684.xlsm

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.

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

hi martin, cant open form, i get the following error msgs...

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

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

sorry, pwd removed
zSearch-form_shape--1-.xlsm

I'm sorry but that can't be it since it still has this

Option Explicit
Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwnd As Long) As Long

Select allOpen in new window

which will cause the same error you got above.

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

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.

i tried sending you a private msg, did you receive?

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?

that all looks the same, so what is different between the original & the other one?

the original still does not allow me to open, see screenshot below...

Which workbook is "the original"?

as per the one i attached above

"zSearch-Form---Master-1.1.xlsm"

Try this version which should open for you.
zSearch-Form---Master-64-bit.xlsm

hi martin, i am at work now & your wksht does work for me here...i dont know at home though..

now your xyz.xlms file you posted yesterday does not work for me here at work either, see following error msg.

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-bit.xlsm does NOT work, see screenshot below for msgbox shown..

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?

Try this one.
84bit.xlsm

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

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?

- 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..

thankyou martin for your patience & persistance to assist me with this task, FINALLY opening it at both home & work has worked!

You're welcome.