+ Reply to Thread
Results 1 to 4 of 4

using VBA to create user forms

  1. #1
    Registered User
    Join Date
    08-21-2008
    Location
    South Africa
    Posts
    37

    using VBA to create user forms

    I am new to VBA. I created a user form for our trainng courser evaluations. The problem I hae is writing the code behind it. I get several error message even though I am using the online tutorial. Here is one line tht was highlighted

    Please Login or Register  to view this content.
    What am I doing wrong. Can anyone tell me were I can get a step by step guide to creating a user form complete with code?
    Last edited by VBA Noob; 08-21-2008 at 08:50 AM.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon gelandl

    ...and welcome to the forum!!

    First off, there needs to be a "." in this line :
    Please Login or Register  to view this content.
    thus :
    Please Login or Register  to view this content.
    Not sure if that's a typo or not ...

    If this doesn't sort it, you may have to post the workbook so someone can take a look at it,

    I don't know of any sites that offer help with UserForms, as they can be so versatile. Moderator royUK has an example of a userform complete with code here that you might like to look at.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437
    If the code is exactly as you posted then the additem code is not within a routine.

    Does the course you are using not have a trainer to assist you?
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    As Andy points out, the code should be in the UserForm Initialize or Activate event.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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. User forms to template
    By Hatrick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2008, 01:35 PM
  2. Resolved >>> Creating new sht from template sht & filling in summary sht - userform
    By lou031205 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-23-2007, 04:10 PM
  3. Create User Forms of "The Course Booking Form"
    By seanyeap in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-04-2007, 04:01 AM
  4. Using Sheets from User Forms
    By banquo_ws in forum Excel General
    Replies: 0
    Last Post: 12-06-2006, 12:41 PM
  5. Need help on Worksheet_Change & User Forms
    By vbarookie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2006, 10:46 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