Using Custom Forms to add a mutil-line text box that enters data into a spreadsheet

**nschneemann** · 04-08-2010, 04:44 PM

I am new to VBA. I am trying to create a user-form comprised of six text boxes and an OK and Cancel Command Button. I want the user-form to popup on a specific sheet "FA" when an existing button is clicked (this button clears other areas of data) in the spread sheet and the user to fill in the requested data. The spread sheet generates a form, so I need the data from the user form to go into specific cells in the spread sheet. I will post the code I have below, not much so far.

Private SubUserForm_Click()

Sheets("FA").Range("A2").Value = DocumentTitle.Text
Sheets("FA").Range("A3").Value = AccountName1.Text
Sheets("FA").Range("A4").Value = AccountName2.Text
Sheets("FA").Range("A5").Value = ReviewerName.Text
Sheets("FA").Range("A8").Value = AccountNumbers.Text
Sheets("FA").Range("A12").Value = CashBalance.Text

End Sub

Thanks for any help you can offer.

**Palmetto** · 04-08-2010, 05:02 PM

Please edit your post to comply with the Forum Rules regarding use code tags for VBA code.

Per Rule #3:

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.

As soon as you have added to code tags someone will help answer your question.

**nschneemann** · 04-08-2010, 05:44 PM

I am new to VBA. I am trying to create a user-form comprised of six text boxes and an OK and Cancel Command Button. I want the user-form to popup on a specific sheet "FA" when an existing button is clicked (this button clears other areas of data) in the spread sheet and the user to fill in the requested data. The spread sheet generates a form, so I need the data from the user form to go into specific cells in the spread sheet. I will post the code I have below, not much so far.

Please Login or Register  to view this content.

Thanks for any help you can offer.

**royUK** · 04-09-2010, 01:54 AM

Use the Edit Button to edit the original post, don't duplicate it

Your code should work,but why use the UserForm_Click event? Add a button to the form to add the details

Using Custom Forms to add a mutil-line text box that enters data into a spreadsheet

LinkBack

Thread Tools

Rate This Thread

Display

Using Custom Forms to add a mutil-line text box that enters data into a spreadsheet

Re: Using Custom Forms to add a mutil-line text box that enters data into a spreadshe

Re: Using Custom Forms to add a mutil-line text box that enters data into a spreadshe

Re: Using Custom Forms to add a mutil-line text box that enters data into a spreadshe

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions