Set Default Value of a cell and allow user changes to be made

**elliotencore** · 06-19-2013, 05:43 PM

Hi guys,

I'm trying to set-up a cell that will have a default value based on the contents of another cell, e.g.

If Cell A1 = "Call 1" Then
Celll A2 = "3.2"

If Cell A1 = "Call 2" Then
Cell A2 = "5.5"

However I also want Cell A2 to be able to have user input so that the figure can be changed if necessary - and then when the user selects the relevant Option in Cell A1 again, Cell A2 resets back to the relevant default value.

Hope somebody can help

**AlphaFrog** · 06-19-2013, 05:59 PM

Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code below in the VBA edit window.

Please Login or Register  to view this content.

**elliotencore** · 06-20-2013, 04:08 AM

Doesn't work, This is what I've used:

Please Login or Register  to view this content.

**AlphaFrog** · 06-20-2013, 04:17 AM

Originally Posted by elliotencore

Doesn't work, This is what I've used:

Please Login or Register  to view this content.

Can't change the name of an event macro. The macro has to be called exactly this...
Private Sub Worksheet_Change(ByVal Target As Range)
...and it has to be located in the worksheet's code module.