+ Reply to Thread
Results 1 to 4 of 4

macro - userform issue

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,233

    macro - userform issue

    hello

    managed to write a macro, but having some difficulty executing it!

    i can try to explain it, but it wont help unless you see a file, so i have attached it.

    basically, im wrote the macro to create a userform box so when users open this workbook, they can "sign-in" with their username, initials and date. this way i dont have to chase them to confirm the file they have sent......if someone can pls help me, its rather urgent. thx you.

    - i keep getting a "object required" error in vbn and im not sure what im doing wrong, thxs
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,243

    Re: macro - userform issue

    As workbook samples go, this seems to be missing a few essentials ;-)

    No data, no code, no explanation of what you have before and after ...

    it's a .xslx, hence no macros.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,233

    Re: macro - userform issue

    is there a reason why the popup box or userform box is not appearing?!! pls help txs

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: macro - userform issue

    Read TMShucks' post, then attach a file with your code in
    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)

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