[mso] Is there an EASY way to create a data input form for Excel?
- From: "Roger" <rogerbid@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 26 Jan 2005 20:17:20 -0500 (EST)
Hello everyone!As usual (it seems) I am in a difficult position of having to do
something far quicker than I would like. This time, I have to create a 'data
entry form' for people to use in order to complete a spreadsheet created in
Excel. I have looked at various visual basic editor solutions but while I would
love to get to grips with this I fear I do not have the time!I have been given
a completed Excel file which in my view is very poorly executed because a new
user opening the file is confronted with a mass of cells, each of which are
totally unprotected and open to alterations, deletions etc, and there is no way
for a new user to easily pick out what data he has to enter. I hoped there is
an easy way to create a separate form in which the cells requiring input are
listed from top to bottom with a text box alongside where the user types
whatever is appropriate. Having completed the list, the entries would then be
transferred to the Excel sheet and the formulas etc would
then work their magic.Initially I thought Excel may offer something similar to
Word's Form / Text Form Field (where the rest of the sheet is locked and
protected from inadvertent changes) allowing the user to tab from one cell to
another but it appears there is no such option.After looking for solutions I
have come to the realization that a 'visual basic input form' is what is
required but I have not found simple instructions for creating such an animal.
Can someone please direct me to a 'Simple as 1,2,3,' type tutorial for this, or
better still can I copy and paste a prebuilt form into my Excel workbook?I am
sorry to ask such a long question but hopefully I have adequately described
what I am seeking. I have to try to fix this up by Monday so time is against
me, here in Australia it is already Thursday mid-day!Thanks for any assistance
offered,Best wishes, Roger
_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
