• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Stuck on Excel kindly help

bgusti

New Member
Hello everyone -
I've been stuck on this and needing the kind help.

I have this register and form. I would like the data at H3 on sheet B, to be automatically changed depending on the cell selection from sheet A starting at B8 then down the column for more data.

Thank you in advance and I look forward to the kind guidance,

Regards

Ben
 

Attachments

  • FRM4223.1 Current DC Log.xlsm
    163.8 KB · Views: 4
You've already got pretty close in sheet A's code module; try changing it to:
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Range("B8:B2000")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Sheets("B").Range("H3").Value = Target.Value
Application.EnableEvents = True
End Sub
(Untested)
 
Works here.
 

Attachments

  • Chandoo48816FRM4223.1 Current DC Log.xlsm
    163.9 KB · Views: 4
Back
Top