+ Reply to Thread
Results 1 to 3 of 3

"Named Range" Data Isolation

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    Bahrain
    MS-Off Ver
    Excel 2003
    Posts
    19

    "Named Range" Data Isolation

    Hi,

    I was struggling to figure out how to properly code my attached project.

    I have an Excel Form to fill in some areas using a VBA UserForm. The Excel form formatted into two Parts:

    1. The upper area which rows can be added or deleted depending of what infos inserted.
    (Not part of VBA code)

    2. The lower area which user can select items using a UserForm with CheckBoxes and select whatever he desire to add to the lower area of the form.

    I named "DataHere" the Range at the lower area of the form where the selected choice will go.

    Attached is my project and would you please kind enough to correct it?

    Thanks in advance

    THE CODE: (not working properly)

    Please Login or Register  to view this content.
    NOTE: Just for you info: http://www.ozgrid.com/forum/showthread.php?t=154114 (hope you don't mind)
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: "Named Range" Data Isolation

    Hi bong25

    Your code "does some things". This
    THE CODE: (not working properly)
    doesn't explain what you wish the code to do. We can probably make it do 30,11 different things. Which of that 30,11 do you want it to do?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: "Named Range" Data Isolation

    How does the user select where to add the data from. Your code does nothing to indicate where the selection should go
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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