Form Control Combo Box Question

[dmill8023]

Hello all! I have a question regarding Form Control Combo Box. I have developed a very simple Combo Box in Form Control where I have a list of 16 cities. When selecting a new city, I want a corresponding cell ($G$1) to update to the new cell I've selected. So, if I select Atlanta from my Combo Box I want $G$1 to show Atlanta. If I select Chicago from my Combo Box I'd like G$1$ to show Chicago. Does anyone know how to make this happen? I can't do an equals formula and am new with Combo Boxes. Thanks everyone for your help!!

 

[Sahak]

Hi,

I’m not sure if this is what you want

 Private Sub ComboBox1_Change()
    Range("G1").Value = ComboBox1.Value
End Sub

 

[dmill8023]

I'll admit I'm an extreme novice when it comes to writing VBA code in excel. I was not able to get it to work. I went through Developer-->Visual Basic-->VBAProject (Book1) and I entered the code under Sheet1, Sheet2, ThisWorkbook and nothing seems to work...? Apologies for the inexperience

 

[Sahak]

You are saying

 I have developed a very simple Combo Box in Form Control

Open (do not run) User Form & Double click on ComboBox1 & enter code there.

 

[dmill8023]

I was unable to get the code to work...I ended up using data validation list for my drop down and it works well enough. Thank you for your assistance. I am taking an Excel class to hopefully gain a better understanding of VBA within Excel

 

[Sahak]

Good luck