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.

Unfortunately, I'm from the States (Oregon). 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.

Take care,

Golf




"Bob Phillips" wrote in message ...
Golf,

It would seem to me that you don't need a userform for managing the data. If
you have structured data, as you seem to suggest, you can use Excel's
built-in Forms.

Just ensure that you have column headings, and goto menu DataForms and
voila, a ready built forms application, and automatically mapped to the
worksheet.

By the way, are you a UK Housing Association. If you are, I would be willing
to assist you voluntarily on the project.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"golf4" wrote in message
m...
Hi, everyone -

Starting up a new work project voluntarily (scary --- I know). Some
people I've talked to say that Access is the way to go on this one,
but I really feel more comfortable with Excel. So, I'm gonna give it a
shot.

The project includes building a rent comparability database. I work
for a large public housing authority where the requirements state
that, before approving a family to rent a Section 8-assisted unit, we
must evaluate whether the rent, type of unit, unit size, etc... is
comparable to what the proposed Section 8 landlord is proposing to
rent on the program.

I have already taken a number of initial steps: Sheet 1 includes a
userform with about 30 textboxes that I want to use to enter the
existing rent comparability data we have located in a number of
binders. Sheet 2 now has the columns built for each of the 30 items:
Comparaility #, Unit Type, BR size, Rent, Rent Change Date, etc.... I
alo have created 2 command buttons, within the userform, that will
close the userform and one that I would use to load the entered
textbox data into Sheet 2's columns. (GEE, didn't want anyone to think
I'm gonna ask you guys to do EVERYTHING!!!)

SOOOOOO, the first question I would ask is help on VBA code that I can
use is, after I enter the applicable data in all 30 textboxes, how I
would (1) load the data into Sheet 2's rows and (2) have the code
enter the data so that it is loaded row after row moving down Sheet 2?

I do realize my posting is sizable, but I wanted to give as much info
as I could without having my fellow posters nod off.... :)

I really appreciate the continued assistance I get from everyone here
on my projects.

Thanks,

Golf