Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Arbitrary data to Textboxes in UserForm
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Dave Peterson, post: 6447819"] Try specifying the sheet that contains that range: Private Sub UserForm_Initialize() TextBox1.Text = worksheets("Sheet1").Range("B" & Int(123 * Rnd) + 2).Value TextBox2.Text = worksheets("Sheet2").Range("B" & Int(123 * Rnd) + 2).Value TextBox3.Text = worksheets("Sheet2").Range("B" & Int(123 * Rnd) + 2).Value TextBox4.Text = worksheets("Sheet2").Range("B" & Int(123 * Rnd) + 2).Value End Sub [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Arbitrary data to Textboxes in UserForm
Top
