+ Reply to Thread
Results 1 to 1 of 1

Button action invoking specific cells

  1. #1
    Registered User
    Join Date
    07-03-2015
    Location
    Bangalore, India
    MS-Off Ver
    2013
    Posts
    4

    Button action invoking specific cells

    I am checking documentation of a product and at the end of the process I created close to 200 image files. Now to make things quite easy, I wrote a simple script that would have button. One of the buttons asks user for installation dir of the help. Then I created buttons in loop like htm2, htm3..... so that when each is pressed then two things happen. One the htm page opens where I found mistake and also the image gets inserted in active sheet so that user get all info at one place.

    Please look at the code:
    Please Login or Register  to view this content.
    Please check the image file for clearity.

    My problem is that when I invoke action say htm2 it calls the sub. I need the sub to understand that now i have pressed htm3. you can see that I have hard coded : ie.Navigate ActiveSheet.Range("F2").Value & ActiveSheet.Range("D2").Value and FileName = ActiveWorkbook.Path & "\" & ActiveSheet.Range("C2").Value & ".png"

    I need to get info like this:
    (Application.caller).caption or the cell for the button and set ie.Navigate to F3 and also the png part to C3. So, press button htm2 it takes info from 2nd row, press htm3 takes info from row 3....so on.

    I have just started VBA, hope I am excused for a silly question.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Button to copy specific cells to another sheet, lock button if cell has text
    By elmerg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-14-2014, 02:10 AM
  2. Action Button Links
    By danl8619 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2009, 10:07 PM
  3. Action Button Links
    By danl8619 in forum Excel General
    Replies: 1
    Last Post: 10-03-2009, 09:55 PM
  4. Replies: 1
    Last Post: 09-17-2007, 09:57 PM
  5. Placing action on a button!!
    By loopoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2005, 08:54 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1