Auto populate textbox value based on combobox value

[justin1202]

Hi, I got an excel file I need some assistance. I'm currently facing an issue which is that when I select the car model, I want it to be able to auto show the price on the price textbox. I have attached the file for reference.

[nilem]

Hi justin1202,
try this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[LJMetzger]

Hi justin1202,

Try the attached file, which uses the following modified code. Changes are in red. I didn't add any comments in the code, because that would destroy the mystery of the existing code.

In the UserForm module

Please Login or Register  to view this content.

Lewis

[justin1202]

Hi, thanks nilem and LJMetzger. Both of your code works..