PC Review


Reply
 
 
Mauro
Guest
Posts: n/a
 
      18th Dec 2004
Hello,

I need to create a sheet of 7 columns. To avoid errors I would like an
userform to be used to input the data. How can I make sure that the data
inserted in the userform goes into the next available row? I use office 11.

Thanks a lot


 
Reply With Quote
 
 
 
 
Frank Kabel
Guest
Posts: n/a
 
      18th Dec 2004
Hi
maybe use:
http://j-walk.com/ss/dataform/index.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Mauro wrote:
> Hello,
>
> I need to create a sheet of 7 columns. To avoid errors I would like an
> userform to be used to input the data. How can I make sure that the
> data inserted in the userform goes into the next available row? I use
> office 11.
> Thanks a lot



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      18th Dec 2004
And Debra Dalgleish has some get started with userforms notes at:
http://www.contextures.com/xlUserForm01.html


You may want to look at excel's built in Data|form, too.

Mauro wrote:
>
> Hello,
>
> I need to create a sheet of 7 columns. To avoid errors I would like an
> userform to be used to input the data. How can I make sure that the data
> inserted in the userform goes into the next available row? I use office 11.
>
> Thanks a lot


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill userform textbox from userform listbox clik event GregJG Microsoft Excel Programming 1 7th Dec 2008 03:05 PM
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) Corey Microsoft Excel Programming 2 9th Jan 2007 02:01 PM
Userform to enter values and shown in same userform in list helmekki Microsoft Excel Programming 0 19th Nov 2005 04:23 PM
Looping procedure calls userform; how to exit loop (via userform button)? KR Microsoft Excel Programming 6 27th Jul 2005 01:57 PM
Activating userform and filling it with data form row where userform is activate Marthijn Beusekom via OfficeKB.com Microsoft Excel Programming 3 6th May 2005 06:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:45 AM.