Doing search and update in workbook with userform
I have created a userform that can input data to worksheet from the form using multiple texboxes.. I now need codes for search, display and update the data on my worksheet,, I am thinking of a combobox to select a column criteria, textbox for the search purpose, and fill the same textboxes I am using to input data for update purposes.. thanks in advance to whoever might help me have a good day guys
Can you post a sample workbook with your userform and code in it?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
thanks for replying,, here is the file u can check,, sorry for the noob codes,, I'm just starting at using forms.. hope u can enlighten my problem thanks
aaaaaa.xlsm
I have looked at your sample form and noticed that some of your code, the add-item code in particular, can be eliminated of you put the list in another worksheet in the same workbook and use that range for the combobox, which would shorten up your code a bit. Let me know if you'd like for me to change that for you. Also, I'm not quite understanding the Trim part of your code. Looking at what it is doing, the Trim part isn't needed, I don't think. I can change that part of the code as well to shorten it up a bit if you'd like.
Now, onto what you really came here for. IF I understand correctly, you want another combobox where you select data from a particular column and have the info from the matching row display in your userform so that you can make changes/updates to it?
sir gmr4ever1, since I am new to this, and have a little background in coding I only derive codes from forums and try to understand it as much as I can, thanks for the offer but I think I can only debug this codes the way I understand them, about the trim part, that it validates the form of blank entries,, cause I need those information to be filled up, like forcing the user to fill them up,
And about my problem, Yes I want another combo box for column select criteria and search for values under that specific column and fill all textboxes accordingly,, I have updated the form will attached it here..
And I found another problem if you don't mind, the data adding of the form doesn't block duplicate entries.. I would appreciate if it would be solved...
DATA ENTRY.xlsm
Here is the updated form
jhinruiz28,
Just wanted to let you know that I haven't forgotten about you here. Do you still need help with this or have you made progress or resolved it?
gmr4evr1
thank you for not forgetting about me
I have been in loops trying to solve this.. your assistance will be greatly appreciated :D
At this point I have something that I am about to implement with my UserForms. It's an "option" where the user double clicks any cell in a row and it opens the user form and populates all the information from that row in the appropriate text boxes and allows them to edit/update as needed. Does this sound like something that would be helpful to you?
hmm.. it seems to be an interesting option..
but I'm trying to limit the access of my users to just the userform alone..
I think I won't be able to take that option sir..
btw I have done the search option..
filling-up the corresponding textboxes that is designated to a column in my database, but for a single criteria only..
I can't figure out the combo box that can change my criteria column
The access can remain limited to the userform, they just have the option to double click a cell on the sheet, then the same userform opens with the info populated. The sheet can also be protected to keep them from making changes directly on the sheet.
I'm not sure I follow about the combobox issue?
oh I see.. can I take a look at it so I can educate myself further?
hmm about the combobox..
For example I have a search textbox, I only have a single criteria for that textbox,,
what I am thinking about is changing that criteria thru the combobox
Like, for Column 1 contains letters
and Column 2 contains numbers,,
the combobox will let me interchange criteria from numbers and letters..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks