+ Reply to Thread
Results 1 to 3 of 3

Userform Values in an Array

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Userform Values in an Array

    I am using a macro to concatenate and sum values in a worksheet. It uses an array function in which it uses column numbers to put values in an array. With the column numbers "hardcoded" in the macro (e.g. myKeys = Array(1)), it works fine. But, when I created a userform so that I can change the values based on user input, I get a "Type Mismatch" error. Any ideas as to what I am doing wrong?

    Attached is the workbook with both the working and non-working macro. Button labeled "No Form" is the one that is working, button labeled "Form" does work.
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Userform Values in an Array

    maybe so (in sub 'test2')
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: Userform Values in an Array

    maybe you are right!!! Yes.. Thanks.

+ 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. [SOLVED] Userform: How do I use text/values from a spreadsheet to customize the userform?
    By bananajelly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2014, 03:47 PM
  2. [SOLVED] Changed userform combobox to listbox, unable to get userform to retrieve datasheet values
    By dragonabsurdum in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2013, 01:38 PM
  3. Replies: 4
    Last Post: 11-28-2012, 06:09 PM
  4. insert elemnts from cells into array, create a userform with values checkboxes
    By usadream in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2006, 11:30 AM
  5. Userform to enter values and shown in same userform in list
    By helmekki in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2005, 11:23 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