Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform Values into Excel sheet [email protected] Excel Programming 2 February 21st 07 07:49 PM
Insert UserForm Values into Excel sheet Aravind[_3_] Excel Programming 1 February 21st 07 07:31 PM
Userform with Excel chart sheet John Easton Excel Programming 1 June 5th 06 03:16 AM
Userform to enter values and shown in same userform in list helmekki[_104_] Excel Programming 0 November 19th 05 03:23 PM
how to get an excel sheet in a userform Pierre via OfficeKB.com[_2_] Excel Programming 3 November 16th 05 01:40 PM


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"