+ Reply to Thread
Results 1 to 9 of 9

Need help bringing an Excel VBA form to life.

  1. 05-26-2015, 11:35 AM #1
    chris619
    chris619 is offline
    Registered User
    Join Date
    05-26-2015
    Location
    San Diego, Ca
    MS-Off Ver
    2013
    Posts
    6

    Question Need help bringing an Excel VBA form to life.

    Hello,
    I was tasked with creating a form in Excel using VBA but have no clue. I did some tutorials here and there but no luck getting an idea of programming in VBA. I have layed out the form, but cant find the way to actually make the form email once I hit "submit" button.

    Any help is greatly depreciated. I have limited exposure to Excel, and helping a friend that owns a CNC machine with this.

    Attached is the file. It may now show when you open it, but you have to click on Developer ribbon then Visual Basic.

    Thanks,
    Chris
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-26-2015, 04:34 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Need help bringing an Excel VBA form to life.

    Hello chris619,

    Welcome to the Forum!

    What do you want this UserForm to do?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 05-26-2015, 04:35 PM #3
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Need help bringing an Excel VBA form to life.

    Hello chris619,

    Welcome to the Forum!

    What do you want this UserForm to do?
    Reply With QuoteRegister To Reply
  4. 05-26-2015, 04:52 PM #4
    chris619
    chris619 is offline
    Registered User
    Join Date
    05-26-2015
    Location
    San Diego, Ca
    MS-Off Ver
    2013
    Posts
    6

    Re: Need help bringing an Excel VBA form to life.

    I wanted it to be a Excel Template with Macro and be emailed. I found a way of making the button work with this code, but don't know how to link each text field to a cell.
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 05-26-2015 at 04:57 PM.
    Reply With QuoteRegister To Reply
  5. 05-26-2015, 04:56 PM #5
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Need help bringing an Excel VBA form to life.

    Hello chris619,

    There is a lot more to your form than just the email. Do you want to email the workbook the UserForm is in?
    Reply With QuoteRegister To Reply
  6. 05-26-2015, 05:01 PM #6
    chris619
    chris619 is offline
    Registered User
    Join Date
    05-26-2015
    Location
    San Diego, Ca
    MS-Off Ver
    2013
    Posts
    6

    Re: Need help bringing an Excel VBA form to life.

    oh my...what path do you recommend taking other than getting trained...LOL... And yes, I want to be able to email workbook the user form is in. I've tried code after code, but cant seem to get it right...
    Reply With QuoteRegister To Reply
  7. 05-26-2015, 05:05 PM #7
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Need help bringing an Excel VBA form to life.

    Hello chris619,

    I will provide you with the code but what about the rest of the UserForm? Do you want to do anything else with it?
    Reply With QuoteRegister To Reply
  8. 05-26-2015, 05:19 PM #8
    chris619
    chris619 is offline
    Registered User
    Join Date
    05-26-2015
    Location
    San Diego, Ca
    MS-Off Ver
    2013
    Posts
    6

    Thumbs up Re: Need help bringing an Excel VBA form to life.

    I was going to have my friend enter date manually, but is there a way that instead of a text box for date, a drop down or automatic date fill in can happen? I want it to be simple, don't want to ask for too much since its free help. Want him to be able to enter information the text box with appropriate data, he can then send the info to, say, an email address as an attachment.

    Thanks for what you are doing for me...
    Reply With QuoteRegister To Reply
  9. 05-26-2015, 07:28 PM #9
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Need help bringing an Excel VBA form to life.

    Hello chris619,

    Sorry for the late reply. Outlook was giving grief because I had recently changed my gmail password. Finally got Outlook to accept the changes and working.

    One of the purposes of a UserForm is automate data entry. The data can be entered into the form and then transferred elsewhere like a worksheet. If you want to email the data, it will have to be added to a worksheet. The UserForm does not retain input information and the person receiving the email would see blanks. Let me know what information you want to be saved to the worksheet from the form.

    Is the "Submit" button calling the email macro?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. EXCEL for Life Sciences
    By ManRai in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-22-2014, 01:51 AM
  2. bringing up the data -> form... box via macro
    By mdkruse2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2008, 04:01 PM
  3. Initialized Form Life
    By scottintexas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2008, 10:39 AM
  4. Excel Life
    By mikerickson in forum Excel General
    Replies: 0
    Last Post: 05-15-2007, 04:52 PM
  5. bringing up the data -> form... box via macro
    By splodgecat in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-17-2007, 06:52 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1