Results 1 to 20 of 23

Thread: Replace text in cell with picture (or insert picture into same cell)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #17
    VBAX Regular
    Joined
    May 2017
    Location
    Northwestern Arkansas
    Posts
    10
    Location

    Getting closer

    Quote Originally Posted by mdmackillop View Post
    The Event macro asks you to confirm the row you use for z.1 etc.
    Private Sub Worksheet_change(ByVal Target As Range)
        'adjust to suit
        If Target.Row <> 1 Then Exit Sub
    I guess this is where my understanding is less than adequate. Where would this be called in the module? Also, there could be multiple instances of "z.1", etc. throughout the spreadsheet (though never more than one per cell).

    Attached is the current semi-working xlsm for reference.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •