Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Entering Data into Spreadsheet using a Userform

  1. #1
    Join Date
    5th January 2006
    Posts
    9

    Entering Data into Spreadsheet using a Userform

    I created a wizard using a UserForm for data entry. I was wondering how to add the data from the textboxes upon clicking the command button to finish the wizard to the next available line in the spreadsheet instead of having to predefine the location of the data to the spreadsheet.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Entering Data into Spreadsheet using a Userform

    What do you mean by a wizard?

    Do you really mean a userform?

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    5th January 2006
    Posts
    9

    Re: Entering Data into Spreadsheet using a Userform

    Hello again

    I created a wizard using multitabs and the command buttons for next, back and finished. Within each tab is a userform containing textboxes for data input. Data is input within the textboxes for each page using the next command button. When all the data is entered in the text boxes then a finished command button is pressed. The finished command button in theory would take all the data from within each text boxes to the appropriate place within the spreadsheet where further data analysis can be performed. Daily new data will be entered via the "Wizard" and the data will then be reanalyzed. So the new data each day should be the next line of the spreadsheet.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Entering Data into Spreadsheet using a Userform

    This is not really a 'wizard' it's a userform.

    Try to keep to the correct terminology, I think you might be confusing people, you certainly flummoxed me for a minute. But that's probably just me.

    Do you have any code so far?
    VB:
    Dim NextRow As Long 
     
    NextRow = Range("A" & Rows.Count).End(xlUp).Row+1 
     
    Range("A" & NextRow).Value = Textbox1.Text 
    
    

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,463

    Re: Entering Data into Spreadsheet using a Userform

    check these free examples, look at the DatabaseForm
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    About me.

  6. #6
    Join Date
    5th January 2006
    Posts
    9

    Re: Entering Data into Spreadsheet using a Userform



    Thanks again Norie that was exactly what I needed to complete my sheet.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    5th January 2006
    Posts
    9

    Re: Entering Data into Spreadsheet using a Userform

    Thanks Roy for the link to the examples. I will use them in the future as a starting point for other projects.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 8
    Last Post: May 11th, 2006, 07:27
  2. Replies: 2
    Last Post: January 13th, 2006, 10:53
  3. Replies: 7
    Last Post: October 28th, 2005, 21:44
  4. Entering a formula via userform
    By Excelman in forum EXCEL HELP
    Replies: 7
    Last Post: March 12th, 2005, 00:48
  5. Userform for entering data in 2 column table
    By PNeely in forum EXCEL HELP
    Replies: 5
    Last Post: June 20th, 2003, 18:56

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
  •  
porno