+ Reply to Thread
Results 1 to 5 of 5

Custom Design Data Entry User Form for Entering Customer Information

  1. #1
    Registered User
    Join Date
    07-14-2010
    Location
    Seattle, WA
    MS-Off Ver
    PC 03/07/10 | Mac 08/11
    Posts
    43

    Custom Design Data Entry User Form for Entering Customer Information

    I've been searching for something specific that I was hoping that someone has already made, but I'm not finding what I need so I'm hoping that someone here will be able to help point me in the right direction.

    I'm creating a make-shift CRM for my team that'll allow us to save all of our client information that we individually collect into a central database/excel wb. I have a macro that was created by someone on this forum (thanks arlu!) that will be pulling the data from multiple work sheets (1 per user on my team) into a centralized database.

    What I'm looking for is a way to create a custom user form that'll allow me to enter in information designated to a specific cell. Right now, I have 28 columns that'll need to be tied into a text box on the user form. Only 3 boxes need to have data entered into them in order for the user form to accept their information and place it onto a work sheet. I'll also need a way access this data entry form from a work sheet relatively easily.

    Thanks!

  2. #2
    Registered User
    Join Date
    07-14-2010
    Location
    Seattle, WA
    MS-Off Ver
    PC 03/07/10 | Mac 08/11
    Posts
    43

    Re: Custom Design Data Entry User Form for Entering Customer Information

    Also, I've come across these solutions but they're not quite exactly what I need, but I will point out what about them I like.

    http://www.contextures.com/xlForm02.html
    I liked that it has the ability to post the date of when the button was pressed
    Easy customization

  3. #3
    Registered User
    Join Date
    07-14-2010
    Location
    Seattle, WA
    MS-Off Ver
    PC 03/07/10 | Mac 08/11
    Posts
    43

    Re: Custom Design Data Entry User Form for Entering Customer Information

    Anybody? Maybe point me towards a thread that's already covered this and I can start building my own?

  4. #4
    Registered User
    Join Date
    07-14-2010
    Location
    Seattle, WA
    MS-Off Ver
    PC 03/07/10 | Mac 08/11
    Posts
    43

    Re: Custom Design Data Entry User Form for Entering Customer Information

    So i've created the custom form and now I just need to create the VB code with one of your guy's help hopefully.

    I've labeled all the text boxes and all the buttons, and I entered in some code that I had found from another tutorial online. My brain is completely fried and I normally would be able to figure this out but I think I'm just a little bit over my head.

    help?

    (xlsm workbook attached)

    Here's the VB code that I'm pretty sure I have botched.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by dizzle; 04-18-2013 at 02:56 PM.

  5. #5
    Registered User
    Join Date
    07-14-2010
    Location
    Seattle, WA
    MS-Off Ver
    PC 03/07/10 | Mac 08/11
    Posts
    43

    Re: Custom Design Data Entry User Form for Entering Customer Information

    bump.

    Starter code? Help! please!

+ 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