+ Reply to Thread
Results 1 to 2 of 2

Activate UserForm in Personal.xlsb from Any Workbook

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    Not of this world
    MS-Off Ver
    Excel 2013
    Posts
    37

    Activate UserForm in Personal.xlsb from Any Workbook

    Hello,

    First, thanks in advance for your help with this one. I have searched online and cannot find a solution; although, I may be asking the question wrong. I have a UserForm in my Personal.xlsb workbook that I need to activate from another workbook (any workbook). I have created a Data Validation List in Workbook X and want to activate my AddReject UserForm in my Personal.xlsb when any cell in Column F of the workbook I'm working in is equal to "Rejected". I am only able to successfully activate the AddReject UserForm when the form is in the workbook I am working in rather than my Personal.xlsb workbook. My code to activate the AddReject UserForm is below. Is it possible?

    HTML Code: 

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Activate UserForm in Personal.xlsb from Any Workbook

    Please Login or Register  to view this content.
    source here
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

+ 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. Can't hide my PERSONAL.xlsb workbook
    By highlystrung in forum Excel General
    Replies: 7
    Last Post: 05-19-2018, 05:06 AM
  2. Trouble passing variable to Userform in Personal.xlsb
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2015, 05:26 PM
  3. [SOLVED] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  4. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  5. [SOLVED] Personal.Xlsb Workbook.Activate not working
    By Aaron092 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-22-2014, 10:28 AM
  6. Add procedure to PERSONAL.XLSB with a macro from another workbook.
    By dimattia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 10:21 AM
  7. Run userform in a worksheet from personal.xlsb
    By crossy5575 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2012, 05:29 PM

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