Adding information

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.

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

Before you add the record, check to see if it's in that range:

if application.countif(yourrangehere, yourvaluehere) > 0 then
'it's already in that range
else
'do the add!
end if



bach wrote:
>
> I have used the one for creating a user form contextures thanks.
>
> I need to check that the Id given to a member is unique and not
> currently on the database How would I go about checking this ?
>
> --
> 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

If the range is extremely large, =countif() can be slow.

if isnumber(application.match(yourvaluehere, yourrangehere,0)) then
'it's already there
else
'do the add
end if



Dave Peterson wrote:
>
> Before you add the record, check to see if it's in that range:
>
> if application.countif(yourrangehere, yourvaluehere) > 0 then
> 'it's already in that range
> else
> 'do the add!
> end if
>
> bach wrote:
> >
> > I have used the one for creating a user form contextures thanks.
> >
> > I need to check that the Id given to a member is unique and not
> > currently on the database How would I go about checking this ?
> >
> > --
> > 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

--

Dave Peterson