+ Reply to Thread
Results 1 to 3 of 3

Will using For Loop be faster for textbox value transfer to cells?

Hybrid View

  1. #1
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,271

    Re: Will using For Loop be faster for textbox value transfer to cells?

    I doubt it's faster with a loop but your code looks far better and is shorter that way and takes away writing time.
    I never rename Objects for coding purposes.

    @ Deep

    Something like this writes 10 textbox values to 10 rows in worksheet.
    for i = 1 to 10
        cells(i,1) = me("textbox" & i).text
    next
    Last edited by bakerman2; 04-30-2018 at 04:59 AM.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Loop Through Rows faster
    By rollin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2018, 01:27 PM
  2. [SOLVED] For Each Loop (Make it Faster)
    By ExcelQuestion in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-03-2015, 11:36 PM
  3. [SOLVED] faster way to loop
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2015, 12:09 PM
  4. Transfer String Data from Textbox to Textbox
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-27-2011, 09:10 AM
  5. Make loop run faster
    By losmi8 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-20-2010, 01:11 AM
  6. Copy the 14 cells and transfer them to another sheet loop
    By Crowbar via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2006, 01:25 AM
  7. [SOLVED] Faster For-Next Loop?
    By dgp@dodgeit.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2005, 06: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