What do you mean by a wizard?
Do you really mean 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.
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.
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
check these free examples, look at the DatabaseForm
Hope that Helps
New users should read the Forum Rules before posting
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
Where to paste code from the Forum
There are currently 1 users browsing this thread. (0 members and 1 guests)