Combo Box Selection Populate Corresponding Cell

[Arios]

Hello,
I am attempting to use an ACTIVE X combo box. to deliver the desired function.

What i would like to do, is make a selection from the drop down combo box, and depending on what i select, have it populate other fields. PLEASE HELP!!!

 

[Andrew Poulsom]

Welcome to MrExcel.

Populate what other fields with what? Maybe you need Data Validation with a List and VLOOKUP formulas in the 'other fields'.

 

[Arios]

Ill be more specific.

I want to be able to select an item in the drop down box that is located "A1"- like Milk, and based on that selection, i would like it to populate B1 will "Dairy"
I used the technique found in this video (https://www.youtube.com/watch?v=cAVsPOvHlQA) and it worked GREAT, except, i need to use the "ACTIVEX" Combobox.

 

[scott_n_phnx]

I agree with Andrew, the Data Validation List would be better to use. I even have the code for it to do what you want it to do. You would have to expand for multiple target values, but that is simple enough.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("G2:G6000")) Is Nothing Or Target.Cells.count > 1 Then Exit Sub
If Target.Value = "My Number" Then
        Target.Offset(0, 1).Select
        With Selection
            With .Validation
            .Delete
            .Add xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
            xlBetween, Formula1:="='my values'!$V$2:$V$9"
            End With
        End With
End If
End Sub

 

[Arios]

I apologize for my lack of savvy'ness- im sure moderators deal with this often ...a couple of questions.

1. the data I need to appear in the drop down-combo box runs from "A1" through "A687". I got this to work by going into properties on the combo box and entering the "list name" i have assigned for that range- so far, so good.

2. the corresponding data appears in "B1" through "B687"- this is the where it would draw from.

this is about as far as i am.

I entered VB and pasted the code, but im not sure which values to adjust?

thank you for your help!!!