+ Reply to Thread
Results 1 to 3 of 3

Need to Have Macro Support More than 1 Line

  1. #1
    Registered User
    Join Date
    08-12-2010
    Location
    Vancouver, B.C., Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Need to Have Macro Support More than 1 Line

    Hi, I'm fairly new to VB and am having trouble with my form.

    I am creating an accessibility review template/worksheet for my staff which uses a userform and automatically inserts and deletes pictures. I've attached the worksheet I am working on. The problem is when I create a button and link it to the macro, is it is only good for that line. If I copy it to the next line, I have to create a brand new macro. If you look at the code I have had to write a macro for all five lines. I want to be able to get at least 100 lines worth. That is 100 macros.

    Is there a way to have the userform come up for each row, but not have to be a custom macro for each line?

    I have a similar problem with the inserting and deleting the picture. When you insert the picture, I have it named so that I can delete it afterwards, but now this is linked to the one picture. I can't add another picture to the other lines because the macro wants to delete the first picture.

    Is there a way to insert and delete these pictures using one macro?

    At this rate I would have 300 macros

    Thanks,

    Jason
    Attached Files Attached Files

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Need to Have Macro Support More than 1 Line

    How about one single button somewhere, which will add info typed into the userform to the next empty row????
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  3. #3
    Registered User
    Join Date
    08-12-2010
    Location
    Vancouver, B.C., Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Need to Have Macro Support More than 1 Line

    I want the user to be able to easily edit the row. At the moment, they can click on the button on that row and all the data comes up and they just change what they need to. Any other suggestions???

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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