By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,117 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,117 IT Pros & Developers. It's quick & easy.

Excel VBA problem

P: 1
Well i have a form and im tryin to link a textbox to a cell so the textbox takes up the data in the cell. The first part of the form is having it look up data and putting it into certain cells. The problem is after the data is in the cell it wont go into the textbox unless i type something in it. All im using is UserForm1.TextBox3 = Sheet1.Range("B2") in the textbox's code. Is there a way to fix this?
Jun 23 '08 #1
Share this Question
Share on Google+
1 Reply


kadghar
Expert 100+
P: 1,295
sure, you're writing the code in the CHANGE event of the textbox. Use anyother event. I'd use the INITIALIZE event of the form, for example:

Expand|Select|Wrap|Line Numbers
  1. Private Sub UserForm_Initialize()
  2. UserForm1.TextBox3 = Sheet1.Range("B2")
  3. End Sub
HTH
Jun 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.