Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 4th, 2011, 05:02 PM
Registered User
 
Join Date: Mar 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Working with 2 or more userforms

I'm trying to write data entered from 2 different userforms to the same worksheet. However, the rows don't match when the data is save in the worksheet. For example, userform1 starts writing in A2 and userform2 starts on A3. I want to have the two userform to start writing in row A2. Please help. Thank you everyone!
 
Old March 4th, 2011, 05:04 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 171
Thanks: 0
Thanked 14 Times in 14 Posts
Default

Can you post your code so i can see it?
 
Old March 11th, 2011, 04:43 AM
Registered User
 
Join Date: Feb 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

1 user form enters data in A2 and the other userform enters data in B2, is this correct?
My assumption would be that you are using a code to find the first empty row in column A, if you run it from Userform 1 it finds and enters data in Row 2, then when you run it from Userform 2 it finds the next empty row and enters the data in row 3.
You will have to supply more details.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with userforms TwEaKFrEaK Excel VBA 3 June 3rd, 2004 06:33 AM
UserForms "locking up" Joss Excel VBA 1 January 10th, 2004 10:42 PM
userforms in excel 2000 p10rpc Excel VBA 2 November 12th, 2003 01:12 PM
userforms winner13 Excel VBA 0 October 19th, 2003 04:16 PM
Userforms DirtyGerty Excel VBA 0 October 7th, 2003 08:41 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.