+ Reply to Thread
Results 1 to 2 of 2

Expanding UserForm's Capability

  1. #1
    Registered User
    Join Date
    Louisiana, United States
    MS-Off Ver
    Excel 2007

    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.

    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
    Alstonville, Australia
    MS-Off Ver

    Re: Expanding User Form's Capability

    have a look here for starter
    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


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