Help

  • Thread starter Thread starter bullandbear1987
  • Start date Start date
B

bullandbear1987

I am having a few problems.

First off, I do not want data to appear when I make a selection change,
but rather when I pick an item to appear automatically.

Whenever I try and use CHANGE rather than SELECTION CHANGE, this
argument doesn't work. 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


Secondly, I would like the data from this argument to appear in a text
box. What is the code I need in order to write up this program?
 
I am having a few problems.

First off, I do not want data to appear when I make a selection change,
but rather when I pick an item to appear automatically.

Whenever I try and use CHANGE rather than SELECTION CHANGE, this
argument doesn't work. 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


Secondly, I would like the data from this argument to appear in a text
box. What is the code I need in order to write up this program?
Click to expand...

Are you running this code from Microsoft Access (the subject of this
newsgroup)? or (as it appears) from Excel? I strongly suggest that
you'll get better answers by posting the question in an Excel
newsgroup. Please scroll down the list of newsgroups on the left side
of the screen (if you're using the web interface) and pick an
appropriate Excel group.

John W. Vinson[MVP]
 
Back
Top