+ Reply to Thread
Results 1 to 2 of 2

Expanding UserForm's Capability

  1. #1
    Registered User
    Join Date
    07-07-2009
    Location
    Louisiana, United States
    MS-Off Ver
    Excel 2007
    Posts
    19

    Smile Expanding UserForm's Capability

    I am trying to develop a way to track my activities at work. I work with steel pipes and on any given day may perform a wide range of activities, each of which I need to track. I would like to set up a form in to accomplish the following:

    I enter the pipe number in the form along with the date, the activity performed and the status. When I click submit I would like VBA to search for the pipe number and from there use the empty columns in the same row to populate only the date, activity and status that were entered elsewhere on the form. This would make it much easier for me for obvious reasons - the elimination of redundant info being the greatest.

    I have no idea where start with this one. I have attached a basic xlsm to better visualize what i'm trying to do. Any assistance is greatly appreciated.

    Thanks
    tony
    Attached Files Attached Files
    Last edited by antonymiller; 05-23-2010 at 07:33 PM. Reason: Solved, thanks

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,324

    Re: Expanding User Form's Capability

    antonymiller
    have a look here for starter
    http://www.excel-it.com/workbook_downloads.htm
    there is a downloadable example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1