+ Reply to Thread
Results 1 to 5 of 5

Using For and Next to fill in User Form Text Box

  1. 03-12-2015, 07:19 AM #1
    Mr_Nick666
    Mr_Nick666 is offline
    Registered User
    Join Date
    03-15-2013
    Location
    South West, England
    MS-Off Ver
    Excel 2010
    Posts
    27

    Using For and Next to fill in User Form Text Box

    I have 38 cell values to add to various text boxes on a sheet.

    Do I have to do them individually (like this)...

    Please Login or Register  to view this content.
    or is there a way to use For and Next as the Eng values run sequentially, as does the information location cell.

    I can't get it work any way I've tried.

    Thanks,
    Nick
    Reply With QuoteRegister To Reply
  2. 03-12-2015, 07:26 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,290

    Re: Using For and Next to fill in User Form Text Box

    Suggest you post a sample workbook.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 03-12-2015, 07:29 AM #3
    AranDG
    AranDG is offline
    Forum Contributor
    Join Date
    06-11-2014
    MS-Off Ver
    Office 2003, 2007 & 2010
    Posts
    119

    Re: Using For and Next to fill in User Form Text Box 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-12-2015, 10:47 AM #4
    Mr_Nick666
    Mr_Nick666 is offline
    Registered User
    Join Date
    03-15-2013
    Location
    South West, England
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Using For and Next to fill in User Form Text Box

    Many, many, many, thanks AranDG! I've been tearing my hair out over this one.
    Reply With QuoteRegister To Reply
  5. 03-12-2015, 10:54 AM #5
    AranDG
    AranDG is offline
    Forum Contributor
    Join Date
    06-11-2014
    MS-Off Ver
    Office 2003, 2007 & 2010
    Posts
    119

    Re: Using For and Next to fill in User Form Text Box

    No worries, I had a similar project some months back, reduced the code considerably! Good luck witht he rest of your project
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Form to select template & then user form to allow user to fill in details in template
    By kopapa in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2014, 03:05 AM
  2. User form to fill in ID number onto another spreadsheet
    By ln1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 07:01 AM
  3. Macro with user form to fill in Information
    By Wskip49 in forum Excel General
    Replies: 8
    Last Post: 09-22-2011, 08:19 PM
  4. Auto Fill Web Form using Excel User Form
    By vandanavai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2008, 02:26 AM
  5. Best way to fill user form fields
    By evanzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2008, 09:41 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1