+ Reply to Thread
Results 1 to 12 of 12

Dynamically creation of text boxes through a buttonClick

  1. #1
    Registered User
    Join Date
    08-04-2014
    Location
    bg
    MS-Off Ver
    MS Office 2007
    Posts
    71

    Dynamically creation of text boxes through a buttonClick

    Hello,
    I am working on form for CV automation. I stuck with work experience.
    Workflow is the next: Some candidate may have no WE (work experience) and the others may have different "amount" of WE.
    So I need to have dynamic button, which will create another set of fields (4 fields) for another WE, and to drag button below new WE textboxes.

    Please find the attachment below. On user form I ve manually added another WE2 set of fields. Just to explain you better.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Dynamically creation of text boxes through a buttonClick

    You could do it like that, but I think it would get unwieldy - I'd use a listbox with add and update buttons

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-04-2014
    Location
    bg
    MS-Off Ver
    MS Office 2007
    Posts
    71

    Re: Dynamically creation of text boxes through a buttonClick

    Thanks Kyle,
    But I quite do not understand your code.
    Why did you add on top text box which on click erases all fields?
    On add more experince I need to create 4 more text boxes in same order, just below the first set of text boxes..

    Thanks!!

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Dynamically creation of text boxes through a buttonClick

    Sorry, I've no idea what you are talking about? Nothing erases all fields.

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Dynamically creation of text boxes through a buttonClick

    What don't you understand?

  6. #6
    Registered User
    Join Date
    08-04-2014
    Location
    bg
    MS-Off Ver
    MS Office 2007
    Posts
    71

    Re: Dynamically creation of text boxes through a buttonClick

    Thanks you for your patience.

    Firstly, on click Add More Experience form do nothing.

    Please Login or Register  to view this content.
    It should be on click create 4 text boxes below the first set.

    Maybe we didnt understand each other what my problem is?

    Thanks again! Any help is a help for me

  7. #7
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Dynamically creation of text boxes through a buttonClick

    I understand your problem, but please re-read my post. Just change the button names to Add and Edit respectively

  8. #8
    Registered User
    Join Date
    08-04-2014
    Location
    bg
    MS-Off Ver
    MS Office 2007
    Posts
    71

    Re: Dynamically creation of text boxes through a buttonClick

    Oh, Now I feel uncomfortable..I am newbie but this mistake that I've made..
    Ok, your logic is even better than mine. I ' ve edited name of the buttons, but still I cannot figure it out what does Add more experience? In this logic I need only Update. Am I wrong? And now, from array, I will read values and insert it in cells where I need them.

    Later today, I will pack everything and upload a file, just for you to see what I want..a bigger picture

    Thanks again!

  9. #9
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Dynamically creation of text boxes through a buttonClick

    Well add adds a row to the listbox, edit updates an existing option once its been double clicked

  10. #10
    Registered User
    Join Date
    08-04-2014
    Location
    bg
    MS-Off Ver
    MS Office 2007
    Posts
    71

    Re: Dynamically creation of text boxes through a buttonClick

    Kyle,

    OK, now I got it!

    Please look, I ve uploaded my "master file", under tab Work experience.

    The idea is, to populate grey area, if there more then one work expierence this range should be duplicated and formated like this one. I assume that would be no problem with inserting from multi line txtDescription box?

    Please, could you tell me ho to write Delete button for the list?

    Thank you very much!

    P.S. I alternated the name of text boxes we1 = txtPeriod; we2 = txtCompany; we3 = txtPosition ; we4 = txtDescription.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    08-04-2014
    Location
    bg
    MS-Off Ver
    MS Office 2007
    Posts
    71

    Re: Dynamically creation of text boxes through a buttonClick

    Edit> The latest version
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    08-04-2014
    Location
    bg
    MS-Off Ver
    MS Office 2007
    Posts
    71

    Re: Dynamically creation of text boxes through a buttonClick

    Please, refer to this post
    HTML Code: 
    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. Open PDF file on ButtonClick
    By JanF in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2014, 07:58 AM
  2. Update many text boxes at once dynamically
    By crispyhamblin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2013, 03:44 PM
  3. Dynamically create and Place Controls such as CheckBoxes,Text-Boxes in a UserForm
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 05-11-2011, 11:34 AM
  4. Replies: 2
    Last Post: 02-19-2010, 03:55 PM
  5. Dynamically Add Combo Boxes
    By AP in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2005, 08:05 PM
  6. [SOLVED] Copy drop down boxes and associate to cells dynamically in excel
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  7. [SOLVED] Copy drop down boxes and associate to cells dynamically in excel
    By t Killion in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  8. Copy drop down boxes and associate to cells dynamically in excel
    By t Killion in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2005, 11:05 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