+ Reply to Thread
Results 1 to 3 of 3

Checkboxes, Strings and Arrays.

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    Sheffield, UK
    MS-Off Ver
    2013
    Posts
    4

    Checkboxes, Strings and Arrays.

    Hi,

    I'm stuck. I have three groups of varying numbers of checkboxes on a form where the user can select 6 out of each group. Each checkbox represents a string value and I plan to pass the string variable corresponding to the user's selection into a fixed size array for use later on in my code. As one checkbox is ticked, the corresponding variable should be passed to the first empty index in the array. As a checkbox is in-ticked, the associated array index is to be cleared and the user's next selection would fill that gap.

    Not a clue how to go about this though!

    Any suggestions would be massively appreciated.
    Last edited by bacardi84uk; 06-14-2017 at 09:31 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Checkboxes, Strings and Arrays.

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.



    To add a file to a post

  3. #3
    Registered User
    Join Date
    09-03-2014
    Location
    Sheffield, UK
    MS-Off Ver
    2013
    Posts
    4

    Re: Checkboxes, Strings and Arrays.

    I can't attached a sample workbook. This is for a Solidworks 3D CAD VBA macro inserting a table into a manufacturing drawing. The principals of VBA/VSTA programming are the same but I'm not sure anyone could read the Macro without the software and a lot of the declarations are software specific. I'll tyr to attach the macro file and paste the code though. Its a WIP so is messy and needs compressing (tips on that would be appreciated too!)

    Please Login or Register  to view this content.
    The Strings to be passed to the arrays are "0 to 9" for PPE_Array, "A to Z" for Tools_Array and "a to z" for MPwr_Array (yes, case sensitive). The String corresponds to a character in a custom Font I created in order to display a symbol associated with that particular character.



    EDIT: nope the *.swp macro file will not upload (Invalid File). Try a copy of the exported Form itself.
    Attached Files Attached Files
    Last edited by bacardi84uk; 06-14-2017 at 09:45 AM.

+ 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] Search for text in strings using arrays
    By dwsf in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-19-2015, 01:49 AM
  2. [SOLVED] strings and arrays
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-15-2014, 04:31 PM
  3. [SOLVED] Trying to search for list of strings using Arrays,Scripting Dictionary or FileSystemObject
    By downtown1933 in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 10-01-2013, 04:38 AM
  4. Using Byte Arrays vs Strings
    By CyanPile in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2011, 09:28 AM
  5. Comparison - Strings and Arrays
    By jbtenor1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2006, 09:10 AM
  6. [SOLVED] How do I compare two arrays of numeric strings?
    By john.jacobs71 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2005, 01:00 PM
  7. [SOLVED] Help - Type mismatch when running loop with strings from arrays
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2005, 05:06 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