Excel VBA, Userform w/ ComoboBox

[scgamecock]

I am trying to find a way to create a macro that will take the data selected from the combo box and concatenate it with the data found in cells.

For Example:

Combo Box Selection - "Test"

ID (Column A) - Before
12345
98765
99999
55555
empty cell
23232

ID (Column A) - After
12345 Test
98765 Test
99999 Test
55555 Test
empty cell
23232

If any further information is needed, please let me know.

[msanchez]

You'll want to look into looping over ranges using the Range() method and then call the ActiveCell properties to update the values.

Here is a page with a tutorial on using comboBox controls in Excel.

http://www.excel-vba.com/vba-24d-combo-boxes.htm

Good luck,