Darn Programming

  • Thread starter Thread starter bullandbear1987
  • Start date Start date
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?
 
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.
 
Ok,

My problem is that I have tried to change the argument. When I do, the
program doesn't work. Can you please help?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP WITH VBA 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
HELP! 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Help 4
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10

Back
Top