hi all
I create a user-form for record data for employee,s username and password. with add ,search, update and clear button. everything is working fine expect search button, for example , main concern is when i search data with number (1,2,3) i do update the saved data but when i search with word (ram, mahesh..)unable to do this
please find the attachment
please help me to resolve this
thanks
manish
Last edited by manissinha5; 09-04-2016 at 01:09 PM.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I can search data with user "5" but unable to search with "ram"
help please
That code was repeatedly searching to find if the TextBox0.Text was on the worksheet. And if so, where?
Rather than repeating the same code in several locations, this version added a Function, CellsOfPerson that returns the range on the worksheet where the PersonName is found.
Similarly, there is a RangeOfData function that returns the (expanding) range where the data is.
Also, a Close button was added.
The problem with the OP code was that the Update code was searching for Val(TextBox0.Text), which returns a number, frequently 0, rather than for the TextBox0 entry.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
not working
How about now?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
For reference this has been cross-posted here.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hello manissinha5,
It was easier to rewrite your code than try to make what you had work. Here is the new code for UserForm1 and a macro Run display the user form.
Try this out and let me know if this what you wanted. The attached workbook has all the changes.
UserForm1 Code
Module1 CodePlease Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
thanks everyone for help me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks