[mso] Re: mso Digest V4 #19

 


Thanks Linda,I admit I did not know of the Form item on the Data menu, but at 
first glance it does not look as though it is quite what I want! I shall 
persevere though and see if i can use it.It appears it is a bit limited in as 
much as it seeems set on a single column? What I have is a sheet essentially 
consisiting of 2 columns, column A being a 'label' identifying the data in 
column B. The user is required to enter data in cells B3-B6, B8-B13, B22-B23 
and B30-32. The cells in between in Col B contain formulas using the entered 
data. Initially I hoped I could simply 'protect' the entire sheet except for 
the cells I have listed and tab from one to another but i realise this is not 
possible?Any other simple remedies would be very much appreciated, 
thanksRogerFrom: "Linda F. Johnson" Subject: [mso] Re: Is there an EASY way to 
create a data input form for Excel?Date: Wed, 26 Jan 2005 20:37:38 -0500You can 
make a data entry form in Excel without VBA ... It's in the Data menu...cl
 ick on Form ... Or did you know that and that's not what you want?LindaFrom: 
mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of 
RogerSent: Wednesday, January 26, 2005 8:17 PMTo: mso@xxxxxxxxxxxxxxxxxxxx: 
[mso] Is there an EASY way to create a data input form for Excel?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 ther
 e 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).
http://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: