*Paul, *
*Thank you so much for the work you did. Clearly you have a lot of talent and experience since I have been digging through this for a few hours and I was only able to make minor modifications. So I figured I would ask you some more questions and save the time digging into this deeper and watching other videos.* *For my column and row headers the actual headers are more than 1 digit in length. I noticed that your error checker runs after 1 field is totally filled out it runs the moment I type in the first letter or number in the second field. Is there a way to delay that error checking until after the Unit# and mfg step are entered completely? Example: Unit# = 500 mfg step = 2590. The program returns an error the moment I enter ‘2’ then again when I enter ‘5’ and again when I enter ‘9’ then when I enter the last 0 it returns no error since that step is a header. * *Also is it possible to build in another box in the input window which displays todays date. Maybe just something on the top. * *I was able to add some buttons and other functionality but clearly I am very new at this. I see in the code where you have the error checking built in and I tried to delete the if statements that were driving the error checker. But that didnt change when the checker is ran. * *You are the man Paul! Where are you from? * *Thanks again!* On Thursday, June 12, 2014 2:55:36 PM UTC-7, Michael Kohl wrote: > > > Paul, > > Thank you so much for this. This is exactly along the lines I am looking > for. I love the error protection you built into the sheet. > > I know little about excel Macros however i do have some coding experience > and can pick up on what you are doing. I will mess around with it some more > tonight and tomorrow morning and e-mail you with any questions. > > Thank you so much for your quick response. Its amazing to see so many > outstadning people willing to share their knowledge with the world! > > On Thursday, June 12, 2014 6:34:46 AM UTC-7, Paul Schreiner wrote: > ABSOLUTELY possible... > > and a variety of solutions. > > How conversant are you with VBA and userforms? > > Here's what I would do: > I would create a userform that: > Upon opening, it loads data into a Dictionary Object > (MUCH easier to index than an array) > > Then, once the Unit and Step are entered, retrieve the data from the table. > If the user overwrites the value, prompt for approval. > > In the attached file, the userform is opened by Double-clicking cell A1. > > If you REALLY wanted to, you could lock all the cells, and protect the > document > (Except for Cell A1) > then, the user can ONLY update using the userform. > In the macro, you would then unprotect the document, make the change, then > re-protect. > > I threw this together pretty quickly > (in about 40 minutes between phone calls and emails plus one trip for > coffee) > > I didn't spend much time (if any) documenting the code, so if you have > trouble following it, let me know. > > > > > Paul > ----------------------------------------- > “Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > ----------------------------------------- > > > > > > > From: Michael Kohl <michael...@gmail.com> > To: excel-...@googlegroups.com > Sent: Wednesday, June 11, 2014 6:41 PM > Subject: $Excel-Macros$ Macro Data entry by row and column search > > > > Looking for some help with a macro to run a couple operations. Here is the > low down of what I am trying to accomplish. > > I have a sheet with 16 columns and about 500 rows. The first column > contains row headers for the unit number (1-500). the first row contains > the column headers for 15 steps in manufacturing.(call it A-O for example). > Here is an example. > > A B C D E F G H I J K L M N O > 1 100 874 454 456 525 > 2 101 845 584 588 651 > 3 103 654 215 > 4 359 > 5 658 489 685 > 6 542 > 7 658 2354 > 8 > 9 > 10 <td style="border-top-color: currentColor; border-left-color: > currentColor; border-top-width: medium; border-left-width: medium; > border-top-style: none; border-left-s > ... > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
