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.


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

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

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

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