+ Reply to Thread
Results 1 to 2 of 2

Userform Textbox to input data to worksheet

  1. #1
    Registered User
    Join Date
    10-27-2009
    Location
    Georgia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Userform Textbox to input data to worksheet

    I have some data that will be entered into a worksheet manually. I created a UserForm that asks for user input to find the proper workbook and then desired worksheet.This part works good. Here is where I need some help....
    I have a textbox that a user will input numeric data (i.e. 1.012). What I would like to do is have the user type in the data and then hit 'enter' and place data in desired cell (C15) and then have the textbox retain focus so another value can be typed in and when 'entered' put in next cell (C16) and so on until I enter all 60 pieces of data.
    I was able to get the data in the first cell (C15) but I have to click back in the textbox to regain focus and I can't seem to get the 'next' data to go to the next cell down.

    Thanks in advance for any ideas/suggestions/solutions.

    Robert

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Userform Textbox to input data to worksheet

    I can't see how that would be easier than actually typing into the cells
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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