+ Reply to Thread
Results 1 to 4 of 4

Need Assistance to Combine Two Code into Single One

  1. #1
    Registered User
    Join Date
    03-06-2016
    Location
    Nepal, Ktm
    MS-Off Ver
    Microsoft Office 7
    Posts
    9

    Need Assistance to Combine Two Code into Single One

    I am totaly new to VBA world and right now I'm completely lost in those below code where i want to combine them both and make able to run on single userform.


    Please Login or Register  to view this content.



    and


    Please Login or Register  to view this content.



    One works well for "Always on top feature" and other one for "Famous minimize button" when run separately, Is there any way, I could combine both of there two in a single code and hence i'll have both minimize button and always on top feature on same userform.

    Any Help will be well Appreciated. Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Need Assistance to Combine Two Code into Single One

    Take the code thats in each of the Userform_activates Subs and place them into new Subs for example...

    Please Login or Register  to view this content.
    And
    Please Login or Register  to view this content.
    Then change your Activate Code to

    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Need Assistance to Combine Two Code into Single One

    Take the code thats in each of the Userform_activates Subs and place them into new Subs for example...

    Please Login or Register  to view this content.
    And
    Please Login or Register  to view this content.
    Then change your Activate Code to

    Please Login or Register  to view this content.
    Disclaimer: You may however also need to do some changes with the Declarations etc but generally that should work.

  4. #4
    Registered User
    Join Date
    03-06-2016
    Location
    Nepal, Ktm
    MS-Off Ver
    Microsoft Office 7
    Posts
    9

    Re: Need Assistance to Combine Two Code into Single One

    Well Good lord, Thank you for your kind suggestins but still I'm stuck. where do i put those code
    Please Login or Register  to view this content.
    as it gies me error i.e "Only comments can appear before end sub.

    I did kind of tried your suggested idea with above mentioned code for "minimize button" not including(as i had no idea where to put this), so when i ran the code i got the userform with no minimize buttton and is kind of frooze on screen and won't let me close it. so i had to close it via task manager.
    I hope I make it clear. I would be really glad if anyone could provide me a complete code for above.
    Last edited by Naya_Soch; 09-22-2016 at 09:23 AM.

+ 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. Combine VBA into a single one
    By JJ77 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2016, 02:11 PM
  2. [SOLVED] Combine values from two or more into a single row.
    By Kimston in forum Excel General
    Replies: 18
    Last Post: 03-01-2015, 07:21 PM
  3. Combine MANY tabs (with single column) into SINGLE tab.
    By nick1000 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2013, 02:31 PM
  4. Replies: 6
    Last Post: 08-31-2011, 10:00 AM
  5. Combine These Functions to a Single Cell
    By BigMike66 in forum Excel General
    Replies: 2
    Last Post: 10-21-2009, 02:13 AM
  6. combine the two into a single formula please
    By Steved in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-07-2005, 09:05 PM
  7. Replies: 9
    Last Post: 08-15-2005, 07:05 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