+ Reply to Thread
Results 1 to 4 of 4

Need help with search and edit functions VBA project

  1. #1
    Registered User
    Join Date
    05-07-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Need help with search and edit functions VBA project

    Ive been working for a couple weeks on a program for my business but im new to VBA and have a few hangups. I would be incredibly grateful for any assistance provided.

    For the most part everything is functioning the way I need it. The file includes a login feature and several userforms to input data to various sheets, send emails, save forms etc. Where my problem lies is, editing my "Master Roster"once new personel have been submitted (i.e. address changes, new email and phone, etc.)

    From my home screen there is a " Add New Tech" button which works great and there is a "search" buttons which is also functioning but what need is an update button in the "search" userform that would allow me to update my txtbox's once the search has returned the results. Ive tried several methods all of which havent worked. It needs to be through the userform because i plan on hiding most of the tabs once the project is complete. And Ive tried the bulit in data form but its not quite dummy proof enough for some of the people using the end file.

    Also there are some pretty talented people on here so any suggestions on better code or a more efficent method of doing some of these actions would be more than welcome. Id like this to look and function as professional as possible.

    DASHBOARD Demo.xlsm
    This is a sterile copy that includes all my code thus far but I had to remove a lot of my sheets to make it fit
    username=help
    pass=help

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need help with search and edit functions VBA project

    one tip, finding the "r" value, look UP column B to find the last used row:

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    05-07-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Need help with search and edit functions VBA project

    Thanks ill check that out now and let you know how it works

  4. #4
    Registered User
    Join Date
    05-07-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Need help with search and edit functions VBA project

    That works well Thanks
    Any suggestions on the editing feature?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple users - Edit by project type.
    By paulhynes70 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2014, 06:15 PM
  2. [SOLVED] Can't edit macro, VBA project is unviewable
    By Julie Williams in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-02-2013, 06:57 PM
  3. Seeing where subs/functions are called within a project
    By ZealotAssasin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2012, 08:06 AM
  4. [SOLVED] How to call functions of a DLL in Excel and in a .net project
    By Dartish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2006, 06:35 PM

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