Debra Dalgleish has a get started with userforms that does what your userform
does.

You may want to look at how she did it:
http://contextures.com/xlUserForm01.html

And a couple of other options...
Excel has a Data|Form that you may like

John Walkenbach has an enhanced dataform at:
http://j-walk.com/ss/dataform/index.htm

(and the code is available for a minor fee ($20 USA), if you want to modify it
to remove/modify the delete portion.)




bach wrote:

I have created a form which the user adds data to, on a button click
procedure I want the data to be check and then added to a spreadsheet.

I dont know how I would go about placing this data in the write
spreadsheet, in the ocrrect place. I would need to place the data at
the end of the data already there. So i need to check where the last
entry is write ??

also i am having issues with

Sheet("wksmain").Select

where wksmain is the name of the sheet.

any ideas would be greatful for any help.

--
bach
------------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
View this thread: http://www.excelforum.com/showthread...hreadid=468520

--

Dave Peterson