Retrieving a ComboBox value

[gemcgraw]

Good day everyone. Where has the year gone!

I've been ripping my code to pieces trying to write this one simple line; however, I can't get my head around it.

I need to pull a value already populated in ComboBox1 from Sheet-B then assign that value to a variable on Sheet-A. I just can't figure out what I'm missing.

Thanks for any help!

 

[mikerickson]

What kind of combobox are you using, ActiveX, from the Forms menu or on a Userform?

I'm confused by "assign it to a variable on sheet A"
Sheet's don't have variables, they have cells.

 

[gemcgraw]

What kind of combobox are you using, ActiveX, from the Forms menu or on a Userform?

I'm confused by "assign it to a variable on sheet A"
Sheet's don't have variables, they have cells.

I writing in VBA and using a ComboBox activeX control. The combobox1 (as I have named it) resides on Sheet-B and has a value of "12". From Sheet-A, I want to "reach over" to that combobox1 and get the value of "12" and make the variable "RowColor" on Sheet-A equal that value of "12".

 

[mikerickson]

This worked for me to get the value selected in the combobox.

Dim myVar As String
myVar = Sheets("sheet2").ComboBox1.Value

 

[gemcgraw]

This worked for me to get the value selected in the combobox.

Dim myVar As String
myVar = Sheets("sheet2").ComboBox1.Value

That was it! I failed to DIM the variable first and was getting odd results. Thanks so much for the tip.