+ Reply to Thread
Results 1 to 5 of 5

How do I use a set of dynamic created textboxes

  1. #1
    Forum Contributor
    Join Date
    03-05-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    301

    How do I use a set of dynamic created textboxes

    Hi all.

    I thought I was being extremely clever when I created a set of dynamic text boxes on a form.

    Please Login or Register  to view this content.
    however, since it's dynamic, I can never know how many are created at runtime. They are labeled txtBoxABC1, txtBoxABC2,txtBoxABC3, etc in the loop.

    How can I write a function that detects which of these textboxes is updated, and allows for subsequent processing?

    I'm sure this is fairly simple (I can write individual functions but that would be dumb as there may be hundreds), but i don't know how to do this dynamically. Can anybody advise please, or point to a website with this info.

    Cheers and Happy Easter!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How do I use a set of dynamic created textboxes

    Doesn't DynamicListCount tell you how many you've created?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    03-05-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    301

    Re: How do I use a set of dynamic created textboxes

    Yes, it does.

    But that doesn't help me, as I do not know how to write the function that takes that into account, which is why I'm asking.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How do I use a set of dynamic created textboxes

    What is it you are doing with the textboxes and what exactly do you want the function to do?

    Validate the input in each textbox? Sum the values in the textbox?

  5. #5
    Forum Contributor
    Join Date
    03-05-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    301

    Re: How do I use a set of dynamic created textboxes

    I enter a value into the text boxes. This value is summed against another value.

    eg:

    Please Login or Register  to view this content.
    This is a standard static sub.

    The kind of sub I need would apply to one of the dynamically created textboxes.

+ 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. counting between dynamic textboxes
    By mabulco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2013, 03:07 AM
  2. [SOLVED] Display value of dynamic ActiveX control textboxes
    By ukflyer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 06:39 AM
  3. Need help to get code created Userform textboxes to fire a change event
    By brusk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2013, 12:06 AM
  4. Dynamic Worksheet Created from hyperlink
    By mxp in forum Excel General
    Replies: 1
    Last Post: 07-08-2007, 06:44 PM
  5. Assign click functionality to dynamically created textboxes?
    By Ouka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2005, 10:15 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