Hiya all!

I recently posted a general inquiry here a few days ago. Tom Ogilvy
responded with a macro that worked well based on my description.

It can be found he
http://groups.google.ca/groups?hl=en...%3D10%26sa%3DN

For some reason, I cannot respond to this thread so I decided to
create a new one with a much more detailed description as to what I
need done.

I will first go ahead and describe the userform for you all. There
are 9 text boxes, one check box with a text box required if checked
and 3 combo boxes with already defined menus for the pull downs.

The spreadsheet that I need the inputed data in the userform
transfered over is setup in 22 columns.

I went ahead and named everything for this process to go a little
smoother. I'll also list which boxes correspond with the proper column
in the spreadsheet.

txtdate (Column A)
txtstart (B)
txtduration (C)
txtresponse (D)
txtarrived (E)
txtcause (F)
txtcustomers (G)
txtlocation (H)
txtequip (I)
chkfollow (Associated text box is txtfollow) (P)
comboOEB (V)
comboFeeder (JKLMN)
combokelcom (U)

Once there is info in all boxes except for the possible check box, the
macro would input this data in an inserted row based on column A and
B. If not, there should be a prompt/error stating that a specific
piece of information is missing. Please remember that I have
subtotals for each month as per my last post. Same dates and times
can occur, which is something I did not specify last time around.

With regards to "comboFeeder", there are 5 possible selections. Each
one corresponds to a column (Either J, K, L, M or N) and the chosen
Feeder should mark an X in the appropriate cell.

Another possible stumper could be involved with the "chkfollow" box.
If checked, txtfollow becomes enabled. If enabled, the text inputted
in the userform should be inserted as a comment in column P. When
chkfollow is checked it should also insert the words More Work into
the cell in column P and highlight the cell in blue.

I believe that's it. This may seem like quite a bit however I'm sure
it's rather simple for those who are familiar with code for userforms.
I am very unfamiliar with userforms and hope to learn a lot from this
experience.

If you have any questions simply post here or email me.

Thanks in advance,

Kris Taylor
www.QuestOfAges.org Administrator