Hi is it possible to use vlookup to update my database?
I'm thinking if it is possible that i will use vlookup to search for the PO number then update the status and completion date on the same column with the help of userform
Sheet 1.jpg
Userform.jpg
Hi again xia0jj, just a side note; it is usually better to just upload a sample workbook, or if your request is extremely clear cut, describe it in clear details. Only if you really think uploading screen shots / pictures will do better should you do it.
You don't need to use VLookup for this.
Because you did not upload a sample, I am guessing your form objects' names.
Please Login or Register to view this content.
多么想要告诉你 我好喜欢你
Hi Millz, I apologize for the brief description.
Unfortunately, the output seems to have problems. It turns out to be in the command button's sheet itself instead of "CustomerInfo"
Last edited by xia0jj; 01-07-2014 at 07:00 AM.
Apologies, missed the periods.
Please Login or Register to view this content.
Hi Millz, everything is done.
But there is one last thing, i have some errors with my clearing of form controls
sorry for my lack of knowledge in excelPlease Login or Register to view this content.
If you want to set it blank, don't enter any spaces. And option buttons' value hold a boolean (true/false or -1/0), so setting a space or blank to it will give you an error.
Please Login or Register to view this content.
Thanks Millz, I'm done with it. Really grateful for your help!
Hi Millz, one more question.
I'm planning to use the PO number to trace the status of the order.
Status Check (Userform).jpg
The PO number and status are under "CustomerInfo"Please Login or Register to view this content.
Sorry again for the brief description
You mean to display the status based on selected PO number?
Try this
Please Login or Register to view this content.
I really don't know what i can say... but you have literally saved my life. Many thanks to you my friend!
I believe i'm done with today.
Glad to help, and you are welcome. Please use Thread Tools at the top and mark your thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks