VBA for replacing cell value on another sheet

[cjwagner4]

I am new to the VBA game so I am having some difficulty with the following situation.

I have a data set format outlined below. I need to create a macro that can update a value on the data set given constraints of Month and Year. For example:

Month | Year | Value
Jan | 2014 | $400

The form (on another sheet) needs to be able to input the value, click a button and then update. Not sure if this is possible but how would I do this? I am thinking that the selection of the month and year to update will be drop down lists.

 

[cjwagner4]

Note: the input form will look something like this

Month: (Drop down)
Year: (Drop down)
New Value: (Text Input)
Submit Button