+ Reply to Thread
Results 1 to 3 of 3

Imput box using Arrays

  1. #1
    Registered User
    Join Date
    06-28-2010
    Location
    Wales
    MS-Off Ver
    Excel 2007
    Posts
    27

    Imput box using Arrays

    Hello,

    I have a vba Userform set to to input data into my spreadsheet.

    and would like to use the 2nd form below to populate an array, then place the array in 3 colums but one 1 row

    screenshot.3.jpg

    here is a copy of the Shreadsheet
    Dads.xlsm

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Imput box using Arrays

    You need to be more specific on where you want the data fields, in this Userform, to go.

  3. #3
    Registered User
    Join Date
    06-28-2010
    Location
    Wales
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Imput box using Arrays

    First think i'm tryont to do it get the contents of the 2d array i've set up to only use one row but still use the 3 colums.

    I need it to go onto the qwer sheet in the Part used, part cost and supplier colums

+ 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. Imput box
    By wayneao in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2014, 03:56 PM
  2. [SOLVED] Using imput box
    By wayneao in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2014, 07:04 PM
  3. Declaring multiple multi-dimensional arrays (jagged arrays) - compile error?
    By dfribush in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-20-2013, 05:06 PM
  4. [SOLVED] New to arrays-where do I find a good beginners guide to multi dimensional arrays
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-04-2013, 07:44 PM
  5. Browse with imput box
    By bhofsetz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-18-2005, 12:32 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