+ Reply to Thread
Results 1 to 2 of 2

Looping through txtboxes, cboboxes and taking values

  1. #1
    Registered User
    Join Date
    12-20-2010
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    15

    Looping through txtboxes, cboboxes and taking values

    Hi,

    I have a form which needs to cycle through all the controls on a form and pulls the data from each and pastes them into a multiline text box when a user clicks the command button.

    The data pasted must only be the data selected, that is to say that the controls that are disabled or not chosen must not have their data pulled. All the boxes contain default text such as "Please Select"

    Based on the criteria selected some of the controls become enabled/disabled.

    I had it working to a point with some simple if /elseif logic but used in conjunction with a variety of AND and OR it started not pulling the data (I was simply outputting the text to a textbox)

    Ideally I need it to cycle through all the controls, establish if the default text is there, if it is ignore it, if not take it and pass it to something to store (an array maybe)

    any help would be greatly appreciated, thanks

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Looping through txtboxes, cboboxes and taking values

    Any sample workbook too.....(see the forum rules)



+ 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