ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform Values into Excel sheet (https://www.excelbanter.com/excel-programming/383684-userform-values-into-excel-sheet.html)

[email protected]

Userform Values into Excel sheet
 
Hi, i am new to VBA, and i created a user form with some radio buttons
and some text boxes. i created some buttons such as next, back and
submit. so my problem is that i want to know if there is a way to
insert the data from the UserForm into a excel sheet in rows so that
i can do some graphs and such when the submit button is pushed.

Thanks in advance.
Aravind


Tom Ogilvy

Userform Values into Excel sheet
 
XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749

http://j-walk.com/ss/excel/tips/tip84.htm

See this tutorial here
http://www.dicks-blog.com/excel/2004...g_userfor.html


http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


--
Regards,
Tom Ogilvy



" wrote:

Hi, i am new to VBA, and i created a user form with some radio buttons
and some text boxes. i created some buttons such as next, back and
submit. so my problem is that i want to know if there is a way to
insert the data from the UserForm into a excel sheet in rows so that
i can do some graphs and such when the submit button is pushed.

Thanks in advance.
Aravind




All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com