Userform with search and edit entries

[Marchenrysaad]

Hello guys,

I am new to VBA and haven't actually learned VBA. I have some background on coding from JAVA and MatLAB. I have a client that needs a userform for data entry so I found one online and edited it a bit.

1. However, the Find button sometimes finds an entry and I can edit it perfectly. However sometimes it doesn't find what I'm searching for even though I have previously added it.

2. I am having an Invalid Property Error in the FindAll code. In textbox10 specifically, if I remove textbox10 i will get the error in textbox11 and then i will have it in the r=c.row

Any help? I will post the code here and I can send you the entire excel file by email per your request

Thank you in advance!

Please Login or Register  to view this content.

[bakerman2]

Better to desensitize your file and post it here.

Include Userform and all code you are using now.

[Marchenrysaad]

Do you want me to attach the excel file to this forum?

[bakerman2]

If possible, YES.

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.

[Marchenrysaad]

I have attached the excel file to the post.

I deleted all rows yet the first entry after deletion started on row 3 and skipped the first 2 rows.

As you can see, if you type Marc in the Name box and press find it will only find 1 result even though there are 2 instances of Marc.

If you type Michel it will not find it.

[Keebellah]

You should not set form heights to values that may display incorrectly on other systems with different screen resolutions.
Not good coding, If you copy code and do not know what it does, check it first before sending it to others.

[Keebellah]

You do not fill the listbox so there is nothing to list, therefore the error

[bakerman2]

This should do it.

Test it and let us know.

[Keebellah]

Looks good

[Marchenrysaad]

Dear Mr Bakerman,

Thank you for taking the time to help me with my code, however I tried your code and still have the same problems. The form you sent has 2 entries of Marc and 2 of Michel if you search for any of them both say Marc not listed or Michel not listed. Furthermore, I added 2 more entries "Camelia" (attached the new file here) and if you search for Camelia it only returns 1 row and not both.

If you may please help me again because I have no knowledge in VBA and just need this to work and finish all my business with VBA.

Thanks again

[Marchenrysaad]

Dear Keebellah,

I'm sorry for any problems this may have caused, but as I told you I have zero background info about VBA. Just a few coding tools. So I didnt know about this before hand. Thanks for the tip!

[Keebellah]

Please keep in mind that the names entered have to be the same.
Camelia is visually the same but the second Camelia has a blank behind the name and for Excel that is an extra character even if YOU don't see it.
So be careful how you enter your values and what is in the cells. a blank (space) is character too.

[Marchenrysaad]

This is another edit, I checked you were right the second "Camelia" has a space before it, even though I didn't insert it, it was just there.

Now both are the same (i hope) yet still not results.

[Keebellah]

Yeah, 'I didn't insert it' perfect excuse but YOU are the one using the file so you're responsible
That the code doesn't do what you want, well my guess is that it needs to be reviewed completely.
Since you do not work with VBA (or do not want to work with VBA) I guess you should contact the person that wrote this for you before you posted it on the forum.
Even if it is a one time project ...
If you have a coding background in Java and Matlab, well it;s not much different. coding is coding, the logic is the same only the syntax varies a little but the main idea is to translate the thoughts of what you are doing and what you want from writing to code.
What is it exactly that you need to have it do?

[bakerman2]

It works just fine only after you have entered the name you need to click the Find-Button above the Listbox.

[Marchenrysaad]

Thank you guys for the help.

I think it works now.

Thank you for taking the time to help.

[Keebellah]

@bakerman2: it doesn't work for him and the reason is that the search is case sensitive.
If you enter marc it will tell you there are two entries but they do not show in the listbox.
I modified the code so that the textbox1 contents are forced to initial upercase (worksheet function Proper) and then it works like the OP wants

My fingers itch to rewrite the code but this will do it for the OP,

[bakerman2]

The ultimate solution is to replace the Name TextBox with a Combobox that is filled with all the unique values from Name Column.
That way you just select a name so uppercase, lowercase, spaces, etc... don't matter anymore.

Anyway glad to help.

[Keebellah]

A modification that helps the search,
Will need some editing but this works too

[Marchenrysaad]

I just checked it out. thats great! and i think it works pretty well

thanks a lot!

[Keebellah]

You're welcome

[Marchenrysaad]

Mr Keebellah,

I sent you a private message.

Please confirm if you have received it

[Keebellah]

Mr Marchenrysaad,
I have seen and read it.
At this moment I am not able to help you. Will be away for about 2 weeks.
Upon my return I shall see if I understand what you require and will gladly help you (if I can)
In the meantime; the code is not that difficult and maybe you should take the 'risk' and try some changes, it will help you understand VBA too.

[vbaia]

A modification that helps the search,
Will need some editing but this works too

Hi.. What if you want to search a keyword across all columns? Would that be possible?

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar or even the same as this thread, we have a rule that you open your own thread on the issue and do not piggy back another member's thread.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread