+ Reply to Thread
Results 1 to 10 of 10

Code for inserting group (image) on open

  1. #1
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Code for inserting group (image) on open

    I have 5 different groups (Group 002, 003, 004, 005 and 007) that need to be inserted on different days. 005 on Mondays, 004 on Tuesdays, 003 on Wednesdays, 002 on Thursdays and 007 Fridays Saturdays and Sundays. I started the below code, but as you can see, I don't quite have it correct.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by jmcole; 11-05-2014 at 08:01 PM. Reason: Attached workbook

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Code for inserting group (image) on open

    Please observe forum rules and put code in code tags. Thanks.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Re: Code for inserting group (image) on open

    Quote Originally Posted by natefarm View Post
    Please observe forum rules and put code in code tags. Thanks.
    Sorry Nate.

  4. #4
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Code for inserting group (image) on open

    This looks very familiar. I do believe I helped you with this before

    Please explain what the problem is. It seems to run successfully from what I can tell.

  5. #5
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Re: Code for inserting group (image) on open

    Quote Originally Posted by natefarm View Post
    This looks very familiar. I do believe I helped you with this before

    Please explain what the problem is. It seems to run successfully from what I can tell.
    Group for page 1 work perfectly. I need a little help with the groups for page 2. I can't get Monday's group to populate on Monday and Tuesday's on Tuesday etc.

  6. #6
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Code for inserting group (image) on open

    Sorry, I'm still not seeing a problem. Attached are the results when I run it for a Monday.

    help results.xls

  7. #7
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Re: Code for inserting group (image) on open

    Quote Originally Posted by natefarm View Post
    Sorry, I'm still not seeing a problem. Attached are the results when I run it for a Monday.

    Attachment 357163
    Yes Nate, Monday works but,,,,,,,,,,, getting the rest of the week to populate is were I'm having the problem. I have tried the below code but I'm not sure where to put the Else's and If's.

    Please Login or Register  to view this content.
    Last edited by jmcole; 11-06-2014 at 09:09 PM.

  8. #8
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Code for inserting group (image) on open

    Can be done one of 3 ways. Personal preference.

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Re: Code for inserting group (image) on open

    Quote Originally Posted by natefarm View Post
    Can be done one of 3 ways. Personal preference.

    Please Login or Register  to view this content.
    Thank you again. I have learned a lot (again) just from this one line.
    Please Login or Register  to view this content.

  10. #10
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Code for inserting group (image) on open

    That's probably the best option for this situation.

+ 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. [SOLVED] Inserting image into userform controls strictly through code
    By DJams in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 11-24-2023, 03:55 AM
  2. Code for inserting objects and appearing as an image from the same worksheet
    By ryanhk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2013, 11:26 PM
  3. [SOLVED] Request Hyperlink macro code to open new image per line
    By ganeshinscribe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2012, 02:27 AM
  4. Inserting Open Event code via VBA
    By Pete in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2006, 02:40 PM
  5. Inserting a worksheet into an open workbook via VBA code
    By manillla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2005, 09:05 PM

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