Change Cell Value based on ActiveX drop down

[excelenergy]

Hey

I have added another dropdown box to a project containing clothing brands I'm working on. This time I'm trying to change the value of a cell, based on the selection in the drop down.

So similarly to another post I made where I wanted to changed the title of a chart based on the drop down, the goal here is to change the value of a cell based on the drop down selection. So I was thinking of one of two ways...

First is this:

Private_Sub DropDown11_Change()
=VLookup(not sure how to reference a value of an active x dropdown,Sheet3!A:E,2,0)
Range("C17").Value = DropDown11.Value
End Sub

Or

Private Sub DropDown11_Change()
Dimdd As DropDown
Set dd = ActiveSheet
ActiveSheet.Cell("C17").Activate
ActiveCELL = dd.List(dd.ListIndex)
End Sub

My post regarding changing the title of a chart based on an active X drop down is here, incase there is a way to combine both of these vba script or if anyone wanted to reference the other one as well:
https://www.mrexcel.com/forum/excel-questions/1052307-match-match-if.html

 

[excelenergy]

Recently I have also just tried it like this, didn't seem to work

Private_Sub DropDown11_Change()
Range("C17") = DropDown11.Value.Select
ActiveCell.Formula = "=VLookup(DropDown11,'Sheet3'!A:B,0)"
End Sub

Hey

I have added another dropdown box to a project containing clothing brands I'm working on. This time I'm trying to change the value of a cell, based on the selection in the drop down.

So similarly to another post I made where I wanted to changed the title of a chart based on the drop down, the goal here is to change the value of a cell based on the drop down selection. So I was thinking of one of two ways...

First is this:

Private_Sub DropDown11_Change()
=VLookup(not sure how to reference a value of an active x dropdown,Sheet3!A:E,2,0)
Range("C17").Value = DropDown11.Value
End Sub

Or

Private Sub DropDown11_Change()
Dimdd As DropDown
Set dd = ActiveSheet
ActiveSheet.Cell("C17").Activate
ActiveCELL = dd.List(dd.ListIndex)
End Sub

My post regarding changing the title of a chart based on an active X drop down is here, incase there is a way to combine both of these vba script or if anyone wanted to reference the other one as well:
https://www.mrexcel.com/forum/excel-questions/1052307-match-match-if.html