Was able to finish writing scripts to load all tables (1,384,800 records). Now just have to wait to get a "fresh" data dump and run it complete. It takes about 4 hours, because I have to use the Development server. thanks for asking.
Now, about your issue. you're "not comfortable when sheet is protected". is the entire sheet locked/protected? Do you have control over the protection? or is it owned by others? how do you want it to behave? can you send me what you have so far and let me look at it? Paul ________________________________ From: Manish <pansari.man...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Mon, January 31, 2011 6:23:04 AM Subject: Re: $$Excel-Macros$$ User form value in current active row I tried the code suggested by you. It�s working� Bt I am not comfortable when sheet it protected. If possible, pls attach the sample file. Thanks once again!! What about your new development �600,000 records into an Oracle database�? I know, you are mastermind and you done it. :) Regards, Manish On Jan 25, 6:38�pm, Paul Schreiner <schreiner_p...@att.net> wrote: > I've got a macro running right now, so I cannot test the code, but I can > describe it! > > Right-click on your sheet name "tab" and select "View Code". > In the VBA editor panel, in the Top-left pull-down, select WorkSheet. > The "default" event may be the Worksheet_Change event > or the WorkSheetSelection_Change event. > If it's the Change event, use the right-hand pull-down to select > the SelectionChange event. > > This macro will "trigger" whenever you select a cell on the sheet. > > It passes the cell "range" as a variable called "Target". > > Now, the issue here is that if you select more than one cell, > the Target variable is an array instead of a single range. > So, I usually test it: > if (Target.count = 1) then > > next, test to see if the column of the cell is column "B" > If (Target.Column = 2) then > > You can save the Row number by using: > CurRow = Target.Row > > Of course, within your userform macros, you can use ActiveCell.Row > > Now, to launch your userform, use: UserFormName.Show > > Give that a try. > If you need more help, let me know and I'll write it when my macro finishes. > (It's loading 600,000 records into an Oracle database.. it takes a while) > > Paul > > ________________________________ > From: Manish <pansari.man...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Tue, January 25, 2011 8:10:47 AM > Subject: Re: $$Excel-Macros$$ User form value in current active row > > Thanks Paul. > My column is selectable. > If user select/edit in the cell e.g. B3, i want to open the user form > and want to write user form value in same row i.e. row3 in column C to > H. And also i want to put total CtoH in column B. > > Thanks in advance. > > Regds, > Manish > > On Jan 25, 5:54 pm, Paul Schreiner <schreiner_p...@att.net> wrote: > > > > > > > Is column B "selectable"? > > > (When setting protection, it is possible to protect the cell > > from changes, yet allow the user to select the cell) > > > If it is, then you can use a Selection_Change event > > and check: > > If (Target.Column = 2) then > > > within the event, you can open the userform. > > > You'll be able to make changes to other cells, > > but to make changes to column B, you'll have to > > know the password and unprotect the sheet. > > > Paul > > > ________________________________ > > From: Manish <pansari.man...@gmail.com> > > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > > Sent: Tue, January 25, 2011 1:37:03 AM > > Subject: $$Excel-Macros$$ User form value in current active row > > > Dear Excel Experts, > > > Can you please suggest me the code for following task. > > > My sheet is password protected and Column B is locked. When user try > > to enter the data in any cell of column B, I want to open one user > > form. > > I am comfortable with build the user form. In my user form I have six > > TaxtBox, I want to write the data of user form in same sheet active > > row column C to H. > > > I know the write the user form data in new worksheet, but I don’t know > > the code to write the data in active row and also the code for open > > the Userform, if my cell is locked. > > > Pls help. > > > Thanks in Advance… > > > Regds, > > Manish Pansari > > +91 9810 88 8281 > > > -- >>--------------------------------------------------------------------------�-------- >- > >- > > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links > >:http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below > >linkhttp://www.facebook.com/discussexcel > > -- >---------------------------------------------------------------------------�------- >- > > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links >:http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below >linkhttp://www.facebook.com/discussexcel- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
