Adding information

  • Thread starter Thread starter bach
  • Start date Start date
B

bach

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.
 
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 no
currently on the database How would I go about checking this
 
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
 
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
 
Back
Top