Excel VBA UserForm ComboBox Lists

[bryanriveros]

gracias el video me ayudo mucho y resolvi los problemas que tenia thanks from Colombia

[chivycambyt]

Dear Sir/Madam,

Thanks for make this topic for me to learn,

I have code error at " line 17: .List(.ListCount - 1, 1) = ComPart.Offset(0, 1).Value"

I don't know why?

I need help.

Chivy,

[bi1iruben]

Why ? Why program to loop through worksheet ranges to build up comboboxes' lists? You already have worksheet ranges predefined ("LookupLists" & "PartIDList" per 2:32) so in the Properties frame (bottom-left area of the visual basic screen) set for each combobox the RowSource parameter as 'LookupLists' & 'PartIDList' respectively. No need to program, and this dynamic if the userform should add or remove items to these lists, whereas your method is static only when the form is first initialised.

[satishvadlakonda2008]

Your Awesome,

Hi ma'am when i'm trying for the code but i'm unable to getting the code, can u plz help to find the code,why u not tell step by step why u change this to onther video clip. right now i'm woking in warehouse it defently use for me.plz help on this.Thanks

[kalimx]

Great video,

How would I modify the code so that every time I entre a value in any of the text boxes the value is placed in the first cell, then second etc. For example, I entre a part number twice then the third time I entre both a part number and a location. Instead of the location text being placed on the same row as the part number, how can I code it so it is place in the first cell (B2) and not B4 next to the part number I just entered with it. (I need to do something similar). Thanks

[kalimx]

Great video,

How would I modify the code so that every time I entre a value in any of the text boxes the value is placed in the first cell, then second etc. For example, I entre a part number twice then the third time I entre both a part number and a location. Instead of the location text being placed on the same row as the part number, how can I code it so it is place in the first cell (B2) and not B4 next to the part number I just entered with it. (I need to do something similar). Tanks

[edsnero]

Dear,

you are a very good teacher, your explanation is clear and exactly,

thanks and I will try to insert a ComboBox in my Userform following

your example. I am old man, but new learling the VBA programming.

Good Work!

[ducksaj]

Hi, could plz help me, I am trying to create a macro to run automatically everytime I change the cells value like " if range ("E7") = "cnh" then" I want to execute the macro if E7 = "cnh" or else exit sub. I hope you have understood me, thank you so much

[contextures]

@ducksaj I've added a new video that shows how to make a message appear automatically when the worksheet is changed, and cell E7 has a specific value.

On my Contextures channel, look for the video - " Excel VBA - Macro Runs When Worksheet Changed"

[johanpxo]

Hi!! would you help me?? =) when i do this exercise in a new book with the code and elements names exactly like you did it appears an error that says (error 1004 in the method 'Range' from object '_Worksheet') what should i do??? i hope a soon answer :D

[contextures]

@johanpxo There's something in your workbook that has a slightly different name than in my example. Maybe an extra space character or something similar?

[Erebo2005]

Muy buenos videos. Good series. Very helpfull and ilustrative.

[tzegaegbe]

This is great! Thanks! Do you think you could do an example with two or three dynamic lists that populate based on your previous response in each combobox?

[contextures]

@jacanasb, you're welcome, and thanks for letting me know that the video helped.

[jacanasb]

my gf has some college work with this user forms... it seems this video has worked for her... so thank you very much... great work!

[3333Smoke3333]

thx for explaining the code.

[contextures]

@3333Smoke3333 You're welcome!