Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bullandbear1987@gmail.com - 10 Oct 2005 21:02 GMT

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?

Reply to this Message

Rick B - 10 Oct 2005 21:18 GMT

This is an Access newsgroup, not an Excel newsgroup.

Signature

Rick B

>I am having a few problems.
>
[quoted text clipped - 12 lines]
> 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?

Reply to this Message

bullandbear1987 - 10 Oct 2005 21:24 GMT

But I am using Excel (VBA) to create this, not Access (VB)

Reply to this Message

Rick B - 10 Oct 2005 21:56 GMT

Then you are in the wrong newsgroup. This is an ACCESS newsgroup.

Signature

Rick B

> But I am using Excel (VBA) to create this, not Access (VB)

Reply to this Message

John Vinson - 10 Oct 2005 22:04 GMT

>I am having a few problems.
>
[quoted text clipped - 12 lines]
>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?

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]

Reply to this Message