Populating textbox using a combo box

Hi,

I am new to VBA and have been trying to work this code to populate a textbox using a combo box.

The combo box is created using a dynamic range so that new data will automatically update onto it. The Range everything2 is also a dynamic range that updates itself when new entries are added.

My makemodel.value contains text about the certain asset and is the combo box that i want to be able to change to populate numberious other information points based around that specific asset.

The "unit.value" is a textbox that was renamed into unit because thats where i want the units to be placed. I have other ones such as category, description but these will be dealt with after i have populated at least 1 textbox.

In the end i would that when my combo box is changed via the drop down menu the userform automatically updates the information contained within the txt boxes. My ultimate goal is that the text boxes can then be changed and the asset ledger would be updated. I would post the sheet but it contains to much sensitive information.

Thanks in advance and if anyone needs anymore information let me know!

Please Login or Register  to view this content.

Hello Mr.Steel,

Welcome to the Forum!

If you can, you should post the workbook. Please remove or change any information of a personal nature or what your company might consider to be confidential. If you need to scale down the workbook then it should be faithful to original in data layout, formulas, and any VBA code. Please include before and after examples of the data along with any comments.

If you load the combobox with the multidimensional dynamic range

Please Login or Register  to view this content.

It's easy to populate the text box

Please Login or Register  to view this content.