Darren
02-23-2005, 01:30 PM
Hi fellow comp slaves:think:
I got some help from MD on this worksheet and it worked well. Different problem now, I need to tab down the sheet from ''D4" TO "E4" and down the sheet to "A36" and then up to "J4 tab to K4" and down to "G36" and then up to "P4 to Q4" an then to down again to the cell just right and below "Process" that is "S48" PLS NOTE PROTECTED SHEET !!!
Information about this sheet.....
this sheet is completed by reps from a care centre and there computer knowledge is very limited, however training is on the cards and this form is intended to make the completion a little easier by using tab to move down the page and then up to the top again. I have looked at tab index in a user form but have nooooooooooooooooo clue how to get the rest of the program that works to work in a user form.
http://www.vbaexpress.com/forum/showthread.php?t=1865
wont let me upload again ???? Above is the link to my file :doh: :doh:
God Bless :cloud9:
Darren
:doh:
Ps thanks guys and ladies for the Help and support
please see attached zip file:help . Password for sheet "press space bar once" when prompted for password. This must be a protected sheet and reset to default once completed. The new info is automatically stored in "Database Building" This sheet builds new information about customers and can be used at a later time by just entering the telephone number.:help
I got some help from MD on this worksheet and it worked well. Different problem now, I need to tab down the sheet from ''D4" TO "E4" and down the sheet to "A36" and then up to "J4 tab to K4" and down to "G36" and then up to "P4 to Q4" an then to down again to the cell just right and below "Process" that is "S48" PLS NOTE PROTECTED SHEET !!!
Information about this sheet.....
this sheet is completed by reps from a care centre and there computer knowledge is very limited, however training is on the cards and this form is intended to make the completion a little easier by using tab to move down the page and then up to the top again. I have looked at tab index in a user form but have nooooooooooooooooo clue how to get the rest of the program that works to work in a user form.
http://www.vbaexpress.com/forum/showthread.php?t=1865
wont let me upload again ???? Above is the link to my file :doh: :doh:
God Bless :cloud9:
Darren
:doh:
Ps thanks guys and ladies for the Help and support
please see attached zip file:help . Password for sheet "press space bar once" when prompted for password. This must be a protected sheet and reset to default once completed. The new info is automatically stored in "Database Building" This sheet builds new information about customers and can be used at a later time by just entering the telephone number.:help