+ Reply to Thread
Results 1 to 15 of 15

Modify code for adding text

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    369

    Modify code for adding text

    Hi,

    I had great help in here earlier today, and now I see that I need to add some extra information to my registrationform.

    Task: Modify code so that information from textbox in userform will be added to the registrationform

    I have attached a samplefile where I manually have added red text to show how I want it to look like after the code has been adjusted


    Tanks in advance

    Best regards
    Øystein
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,207

    Re: Modify code for adding text

    To save reinventing the wheel, you should add a sample of the code from Sintek [or myself] from the earlier post.

    To avoid any further similar issues, please complete a specification your requirements to avoid having to constantly revise any code that has been provided.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,719

    Re: Modify code for adding text

    Maybe
    Please Login or Register  to view this content.
    The inherent weakness of the liberal society: a too rosy view of humanity.

  4. #4
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    369

    Re: Modify code for adding text

    Hi John,

    This has nothing to do with reinventing any code, so I dont understand youre comment. After testing this, I found out I had to be able to register different section since a climbingfacility contains different walls. The code is in the samplefile an there is also an explanation in sheet 3 for what I need to add.

    This registrationform wil be complex when finnish, so I have to solve task by task.

    I am greatful for the help you have provided me, but I dont understand youre comment.

    Best regards
    Øystein

  5. #5
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    369

    Re: Modify code for adding text

    Hi jolivanes,

    Thanks for youre reply, but I have no clue about writing codes. I am trying to study them, but I find it wery difficult to understand, so where in the code should I put that line?

    Please Login or Register  to view this content.
    Thanks for youre help so far!

    Regards
    Øystein

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,207

    Re: Modify code for adding text

    You already have code from your previous post: this is just an addition to that code so start with this previous code supplied by Sintek. Otherwise you are likely to get yet another set of code, diffrent from that already supplied.

    This registrationform wil be complex when finnish, so I have to solve task by task
    Re the above: you do not build a car by starting with a set of wheels then deciding what body/engine/etc you want. Get the design right from the beginning to include ALL parts (requirements).
    Last edited by JohnTopley; 10-12-2024 at 04:16 PM.

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,207

    Re: Modify code for adding text

    Please Login or Register  to view this content.

    ... and apologies as code was with userform! mea culpa!
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    369

    Re: Modify code for adding text

    Thats why this thread is named "Modifying code for adding text"
    I am not asking for help to write a new code, just to do some adjustments of the existing code in the workbook that I have attached to the tread.

    Mayby I could have been more spesific in the first post, but I really cant see the problem.
    You are the pro, so if it cant be done, than I have to find another way to solv this.

    If I should lay out the whole task for this registrationform in one thread, then it would be a lot of tasks to be solved.

    Regards
    Øystein

  9. #9
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    369

    Re: Modify code for adding text

    Thx John,

    This worked perfect I will study this, and try to learn some coding my self. I starting to get old, so bear with me

    Best regards
    Øystein

  10. #10
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,207

    Re: Modify code for adding text

    See post #7: and again, my apologies for my error in reading your post.

    If I should lay out the whole task for this registrationform in one thread, then it would be a lot of tasks to be solved.
    The potential problem with not doing this [lay out the whole task] is that code has to modified significantly: maybe not in this case - time will tell.

    Re "Getting old" ... I am old! Hence my very "senior moment!!
    Last edited by JohnTopley; 10-13-2024 at 03:01 AM.

  11. #11
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    369

    Re: Modify code for adding text

    John,

    I agre with you regarding planing eatch task that reqires one code. This project has different task that will require a code for each, so thats what I mean by solving it task by task.
    I am already planing the next one, so that will be posted tomorrow.

    Pushing 50, but that is just a number

  12. #12
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,719

    Re: Modify code for adding text

    Re: "Pushing 50."
    In other words, just a young pup.

  13. #13
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Bergen, Norway
    MS-Off Ver
    MS 365 Subscription
    Posts
    369

    Re: Modify code for adding text

    Hi John,

    HTML Code: 
    So you saying there is hope

    I dont know what has happened, but some how there is some text "Sikringspunkt" that is not getting registered. I have attached a PDF to show what I mean.

    Please Login or Register  to view this content.
    I hope you can have a look at this when you have time.

    Thx i advance

    Best regards
    Øystein
    Attached Files Attached Files

  14. #14
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,026

    Re: Modify code for adding text

    Please Login or Register  to view this content.
    Last edited by Sintek; 10-13-2024 at 08:35 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  15. #15
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,207

    Re: Modify code for adding text

    Testing the above (and same would apply to my code) :

    1. There is no check for a duplicate entry of "linjenummer".
    2. Can the number of entries for a previously-entered "linjenummer" be changed [requiring re-alignment of existing entries]?
    3. "linjenummer" presumably can/will be re-set to 1.

    For 2. and 3. then cells need to be cleared, not least the "merge across" cells .

+ 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] modify code to add comment when cell in range have specific text or partial text
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2021, 02:40 PM
  2. Modify Code to include search for second text
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2016, 06:15 PM
  3. [SOLVED] Trying to modify this 'text to rows' code to only use semicolons as delimiters
    By MKBR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2014, 01:17 PM
  4. Help modify the VB Code to copy data between 2 text string
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-25-2013, 11:08 AM
  5. How to modify the following code to copy comments containing specific text
    By sureng19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2010, 12:15 PM
  6. Modify Search code to look for specified text
    By mrgillus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2010, 01:23 PM
  7. How do I modify this code to find text?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-29-2008, 03:23 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