Posts by jhazziejhazz

Quote from royUK

Try zipping the file

Hi Roy,

Thank for the response.

Manage to attached the zip file.

Hope this works.

Jhazzie

SAMPLE.zip

Hi Roy,

Thanks for your quick response,

I wonder why the xlsm attachment didn't not push thru,

I can't seem to upload my file, I always get the "The parameter "className" is missing note.

I have uploaded it in google drive, could you possibly check if you can access it.

https://drive.google.com/file/…09aBpPtW/view?usp=sharing

Thanks,

Jhazzie

Hello everyone,

How can I display the search result in this listbox.

Example I want to search for a particular "Part Number" and I want all the records to display in the list box. The idea is for every Part Number there will be several transaction/movement, and I want them all to be displayed in the listbox when I click the search button

(Please see attached image)

Thank you in advance for those who will take time to answer my questions,

Jhazzie

Quote from royUK

Try this amended code

Its perfect, Thank you so much Roy for helping me out.

You are amazing.

Jhazzie

Quote from royUK

Check out my second example. Does it do what you want?

Hi Roy,

Yes it is, however it automatically add the data to the inventory in sheet when I click OK , is there a way for me open the frm_Product_Masterlist, so I can add the new itemcode/part number to the product masterlist database first, before I can enter a new data in the inventory in data entry form?

Thank you so much.

My apology for having a lot of request.

Thank you for taking time to help me out.

Jhazzie

Quote from royUK

Which combobox?

The part number cmbPartNo .

Quote from royUK

This checks the salesman.

I've tidied up some of the code but it could be improved further, especially as this for your work.

Where did you get the original workbook from?

Thank you for your help Roy,

I designed the workbook from scratch, I just copied what I saw from videos on youtube and tried to formulate my own.

I have this data entry form, which has a combobox, the source of this combo box is from a different sheet.

Please help me with codes, that when everytime I enter a data on the combobox that isn't on the list, a pop up message will show, saying something like "Please make sure the code or part number is already on the masterlist"

I have attached a sample of my file.

Please spare my errors, as this is only a trial for my company, and I was hoping to get this running smoothly as soon as possible.

Thank you for those who will take time to help.

You guys are all amazing.

Jhazzie