Results 1 to 10 of 10

Easy Duplication & Assigning of User-Forms

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-23-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2013
    Posts
    259

    Easy Duplication & Assigning of User-Forms

    Hello Everyone,

    So I've started delving into the world of custom user-forms.

    If I take the time to customize a user-form (which I have) can I easily replicate that form and its cell references?

    Hypothetical to help explain my question:

    Say I have a user-form with 4 text boxes and two drop-downs. Each of those 6 fields corresponds to cells A1:A6. The macro to load the user-form is tied to a button sitting in cell A7. If I want multiple rows to each have a buttom that launches a user-form to populate that row's values, can I easily replicate the references and UF projects themselves?

    Do I need another macro to replicate it for me? I'm testing using UF's in a personal sheet, but I'd like to incorporate them into a spreadsheet for my company. Problem is, that sheet will need 20-30 UFs, each UF having multiple fields which will reference cells. I really don't want to manually update all those references (plus, the more I do manually, the bigger the chance I'll make a mistake somewhere that I probably won't catch before it would roll out).

    If you all need more details or more explanation, please let me know. If you could tell me if this is even possible (maybe a way to update/change all range references for everything within a UF), I'd be happy with that. Would love to learn about this before I try to do everything the long and difficult way. And if anyone has some basic macro code I could customize to this effect, I'd be eternally greatful!

    Thanks everyone!

    -LM
    Last edited by liquidmettle; 06-07-2015 at 01:28 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Forms Check Box - Should be easy fix
    By lsteinbach in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2012, 10:50 PM
  2. [SOLVED] User forms - choosing location of your data to be shown in your user form
    By jasonbwt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2012, 08:48 AM
  3. Assigning a macro to a forms button (help)
    By JazzBlues in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2005, 12:05 AM
  4. new user with easy question? not easy for me
    By speakeztruth in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-03-2005, 05:05 PM
  5. [SOLVED] User Defined Functions - Help Text - Make it Easy for the User
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2005, 06:06 AM

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