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

[FDibbins]

Hi, welcome to the forum

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html


(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Marchenrysaad]

I did not know that as this is my first ever forum not only VBA related forum.

Thank you for taking the time to fix this.

I will make sure to abide by the forum rules next time I post a thread.