Darn Programming

B

bullandbear1987

I am trying to finish writing some simple program.


My problem is that when I try and change the arguement from SELECTION
CHANGE to CHANGE, it doesn't work. Can someone help?


Private Sub Worksheet_Change(ByVal Target As Range)
If Worksheets("Sheet3").Range("B3").Value = 2 Then
Worksheets("Sheet1").Range("F3") =
Worksheets("Sheet3").Range("F4").Value
End Sub


My second problem is that I would like my data rather than appearing in

a cell, appear in a TEXT BOX. What do I do?
 
E

Earl Kiosterud

Bull,

Selection change gets fired when you click another cell (or press Enter,
which causes a selection change, after putting something in a cell).
Worksheet_Change gets fired when you change a cell.
 
B

bullandbear1987

Ok,

My problem is that I have tried to change the argument. When I do, the
program doesn't work. Can you please help?
 
Top