Excel VBA - Combobox loading with unique value

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

Nice work and thank you for share. For people who has numerical data in the worksheet, try changing the (.value ) to (.text) in the code.

mikeflores
Автор

Thanks, Sachin your code works excellent.

delhicyclingassociation
Автор

nice good job .... but it will not work if the case is changed ie... John and john both will be accepted do u have a solution to this

jaysoni
Автор

I tried the same code and it doesn't work for me either.  I am running Excel 2010.  I have entered everything just as you have but get "Runtime Error '1004' Application-defined or Object-defined error."

medichugh
Автор

H Sachin, Hope you are doing well, Need a help from you.I just wanted to create one Macro where two dependent combobox will be there and after selecting the values from both comobox some certail columns will dispay with respective date. Dont want to use any Form -just want the simple sheet. Please helpThanks Navneet

navneetkumarchauhan
Автор

Have tried replicating this, but for some reason nothing happens when i click the commandbutton.
you define "Dim total_row as Integer"
but declare the variable as "total_rowS" - is that deliberate?

Velsrojs
visit shbcf.ru