"golf4" wrote in message
om...
Thanks for the responses, guys -

Bob - the reason I'd like to stick with userforms is that I have a
staff that is, somewhat, computer challenged. I already have them
working on an income/rent calculation spreadsheet tool that I've
created and a lot of the data entry is based on "user-friendly"
userforms. I would be concerned that staff would not accept another
tool where they would have to do extra "clicking" to get to data entry
fields. What can I say --- you know about us "lazy" Americans--- :).
In addition, future enhancements to my Rent Comparability tool would
be to have "search" userforms to help filter out the types of units
for comparability.


I'm a (lapsed) mathematician, so don't talk to me about lazy, we invented
it<g.

Going back to the forms, I would try again to suggest that you look at the
built-in. In your OP you mention adding, but what about deleting, or
amending. The built-in takes care of all of that. You could add event code
that fires the form immediately they enter the data columns, avoiding one
user task.

However, if you insist not, you're the boss on this, so here is some code
for your original request for adding a new entry. I am assuming this is tied
to the 2nd command button, so it is run from the form

'find the first free row
With Sheet2
iLastRow = .Cells(Rows.Count,"A").End(xlUp).Row
.Cells(iLastRow+1,1).Value = Me.Textbox1.Text
.Cells(iLastRow+1,2).Value = Me.Textbox2.Text
.Cells(iLastRow+1,3).Value = Me.Textbox3.Text
'etc.
End With

Unfortunately, I'm from the States (Oregon).

Unfortunately? Oregon is lovely.

I certainly wouldn't mind
continuing the communication on the project over the net. I'm not real
sure about the rules and regulations of the UK Housing organizations,
but the project may be to both our advantages. Let me know.


My offer was not based upon any special Housing Association knowledge, but
rather because they are, at least in the UK, a worthy but under-resourced
facility, so it was in a community spirit sense that I was offering help. I
feel that as a Brit, I should be giving my time for UK based projects, so no
offence made, but I would rather not extend that offer. I will of course
respond to any questions that you post on these NGs if I am able, and you
can mail me direct if you have any particular problems, but I'll stop at
that.


Good luck, and I hope the code snippet helps.