check box to select data from 1 sheet and input onto sheet 2

[madmat252]

hi i need a check box or drop down list that once i click on an item it will get data from one cell on sheet 1 and input it into a cell on sheet 2 is it possible. im a complete novice at this and really struggling.

 

[t.powley]

To create a macro that fires on a drop down menu you need to do the following:

in VBProject select the worksheet you have the drop down list on, and paste this code:

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Address = "$A$1" Then
   Application.EnableEvents = False
   If Target.Value = "Item1" Then
Application.Run "Book1!Macro1"
   ElseIf Target.Value = "Item2" Then
Application.Run "Book1!Macro2"
   End If
   Application.EnableEvents = True
 End If
End Sub

Change the Target.Address to the cell containing your drop down box.

Change Item1 Item2 to the name of the items in your drop down selection and also the macro name you want to trigger.

for the drop down box select the cell you want to have the drop down options, open data validation and choose list, assign the range of cells that have all the items in your drop down list.

I hope this makes sense as its been a long day and its also late, have to go to bed...
yawn...