	AllExperts > Excel
	Search

Volunteer
Answers to thousands of questions

Home · More Excel Questions · Answer Library

· Encyclopedia ·

Excel - User form textbox default values

Expert: Stuart Resnick - 3/12/2008

Question
Stuart,
I have a user form where I would like t set a default value in a text box based on previous user input. The process looks like this so far. User input: place component x at minimum of A ft deep and maximum of B feet deep. Program: works out optimum depth and writes to excel then re-opens userform to allow user to place next component. I would like to update the minimum depth to have a default value of the the next round number below the previous actual set depth. That is to say if the actual set depth was 123ft I would like the default min depth the next time the form opens to show as 125ft. Can you help? I think I know how to write the rounding function, but I dont know how to add the value as a default to the textbox which can be dynamically updated. Thanks

Answer
Example: you have TextBox1 in UserForm1. When UserForm1 opens, you want this textbox to default to the value that's in A1 of Sheet1.

Open the UserForm in Visual Basic Editor. Double-click on the UserForm to get to the vba code attached to the form. Then add this code:

Private Sub UserForm_Initialize()
Me.TextBox1.Value = ThisWorkbook.Sheets("Sheet1").Range("a1").Value
End Sub

Add to this Answer Ask a Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here