+ Reply to Thread
Results 1 to 7 of 7

Access userforms

  1. #1
    Registered User
    Join Date
    05-16-2022
    Location
    USA
    MS-Off Ver
    16.61
    Posts
    4

    Access userforms

    Hello,

    I've been using VBA for a bit and I need to create a dialog window with multiple entries, i.e. I need to create a userform. After hours of search, I have not been able to initiate the userforms editor. E.g., when I click on Insert (in VBA), I do not see the option userforms. I've looked in this forum, too, but to no avail. What's a good thread? Who can help?

    Thank you very much!

    Mark

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Access userforms

    Hi there,

    None of the VBA Insert options (Procedure, UserForm, Module, Class Module) will be available unless a workbook is open into which such an object can be placed.

    Regards,

    Greg M

  3. #3
    Registered User
    Join Date
    05-16-2022
    Location
    USA
    MS-Off Ver
    16.61
    Posts
    4

    Re: Access userforms

    Screen Shot 2022-05-16 at 3.04.20 PM.png

    Does this apply to your reply?

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Access userforms

    Hi again,

    I'm using Office 2016, but my VB Editor screen looks like the following:


    VB Editor Screen 2.gif


    Sorry I can't be of more help.

    Regards,

    Greg M

  5. #5
    Registered User
    Join Date
    05-16-2022
    Location
    USA
    MS-Off Ver
    16.61
    Posts
    4

    Re: Access userforms

    Thanks, Greg. Thanks for sharing! I wish mine looked like this!

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Access userforms

    @markf1337
    What version of Excel are you using? It will not be 16.61 but something like 2010, 2019, O365. Please update your profile to your version. It will help to answer all questions and provide solutions that work with your version. Also, if you are running a MAC be sure to note that in your profile because the functions available in Windows are not always available in MAC even if the version is the same.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  7. #7
    Registered User
    Join Date
    05-16-2022
    Location
    USA
    MS-Off Ver
    16.61
    Posts
    4

    Re: Access userforms

    MICROSOFT 365 CONSUMER SUBSCRIPTION

    Is this what you mean?

+ 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] How to access Userforms created with "add" ? How to add some text inside ?
    By Sys111 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2021, 08:53 AM
  2. Running an access append query with parameters from Excel. Access version 2010
    By anthony1312002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2017, 04:48 PM
  3. Access form works with access Viewer but not full version of Access?
    By Shanyn in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-22-2014, 01:14 PM
  4. Excel to Access through Userforms in excel
    By nageshpolu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2012, 06:56 AM
  5. Cannot access or view the properties window in userforms
    By johnjohns in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2011, 01:14 AM
  6. Data Access Pages and Userforms?
    By danny2000 in forum Access Tables & Databases
    Replies: 6
    Last Post: 04-10-2009, 08:28 AM
  7. Manipulating Access database using Excel Userforms
    By Purnima in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2005, 09:22 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