Listbox Prevent Duplicate Entry Userform Excel VBA

[@mohammedelsayed3852]

Good job sir

[@abduljamilnaroei9129]

good dear sir

[@md.monirul1723]

Thanks for this awesome video. How I can add item to listbox using textbox and get sum without excell sheet.

[@razakmcr]

kzbin.info/www/bejne/l3ypdXh_hNJ3orc

[@officeez7980]

This is nice concept, but its not applicable for saving the data in to the sheet. Link text boxes values to the sheet enabling user to save the data or create a database and apply the same prohibition of duplicate value at the excel colums. I am using the same concept (learned from your previous listbox videos) but i am saving the data in excel sheet colums but without duplicate prohibition.

[@razakmcr]

Thanks for watching vdeo. Pla. Watch this. kzbin.info/www/bejne/hYGrhKx9rJx-mKc

[@deepakkumarchauhan4656]

sir, I added product items in listbox now i want to search name of product (i.e. medicine crosin - 125mg,150mg ) , me.listbox1=clear giving error

[@razakmcr]

Tanks for watching pls follow kzbin.info/www/bejne/pKfPXoifm8ydb7M

[@EtiSumiyati-sh1xh]

Me.list_KERANJANGBELI.List(list_KERANJANGBELI.ListCount - 1, c) = Me("textbox" & c + 1) textbox?