+ Reply to Thread
Results 1 to 2 of 2

A way to create a form in Microsoft excel

  1. 12-19-2019, 05:35 PM #1
    richardahughes28
    richardahughes28 is offline
    Registered User
    Join Date
    12-17-2019
    Location
    North Carolina
    MS-Off Ver
    2016
    Posts
    1

    A way to create a form in Microsoft excel

    Hello all.

    I'm currently trying to figure out a way to create a from using this as a template:

    Capture.JPG



    The usage of this would be the user could search for the product and it would auto fill the data. they could also add another part in using this same form.
    now currently this is just an excel template of what I would like for it to look like. the giant blank spaces are for pulling pictures and such. i'm not entirely sure my question makes since but if you need me to clarify a bit more i can try. I'm looking for anyway for this to be possible weather it be a formula or a macro. again though as I said i'm not sure this is possible using excel or even the dreaded access.
    Reply With QuoteRegister To Reply
  2. 12-19-2019, 06:09 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: A way to create a form in Microsoft excel

    First Start with your database.
    Lay out your data in the way that you would expect to see it.

    Next
    Do you really want to use a form. ie a worksheet?
    A Userform is a lot more powerful and controllable.

    if your data is layed out correctly then you could type in a part number.

    A simple piece of code like this will load 100 peices of data:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 12-19-2019 at 06:24 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    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 database form to Microsoft Word document
    By chillz in forum Excel General
    Replies: 5
    Last Post: 02-22-2017, 12:40 PM
  2. Can't install/use Microsoft Date Picker in VBA for Excel User Form
    By GeminiG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2016, 10:20 AM
  3. Microsoft Visual Basic error message when trying to print Excel user form
    By cpieramico in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-13-2015, 04:22 PM
  4. I want to save data on vb form to Microsoft Excel
    By aniruddhaamle in forum Excel General
    Replies: 1
    Last Post: 04-05-2013, 01:57 AM
  5. Microsoft Word Form/Excel Database
    By RevDaniel in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-12-2010, 12:06 AM
  6. How do I create mailing labels from microsoft excel
    By Tim Malle in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-17-2006, 06:45 PM
  7. how to create a dialog sheet in microsoft excel
    By bharat in forum Excel General
    Replies: 1
    Last Post: 01-23-2006, 05:30 AM

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