Re: $$Excel-Macros$$ User form value in current active row

2011-02-08 Thread Manish
rom my computer(s) for a few days. > > I'll try to take a look today. >  I thought I sent it, but don't see it, so I'll have to re-create it. > > Paul > > > From: Manish > To: MS EXCEL AND VBA MACROS > Sent: Mon, Februar

Re: $$Excel-Macros$$ User form value in current active row

2011-02-07 Thread Paul Schreiner
February 7, 2011 10:34:59 AM Subject: Re: $$Excel-Macros$$ User form value in current active row Any help pls. - Manish On Feb 7, 12:12 pm, Manish wrote: > Dear Paul & EE, > > I want to write the value of userform in same PRA worksheet in column > T:AA in same row. > >

Re: $$Excel-Macros$$ User form value in current active row

2011-02-07 Thread Manish
Any help pls. - Manish On Feb 7, 12:12 pm, Manish wrote: > Dear Paul & EE, > > I want to write the value of userform in same PRA worksheet in column > T:AA in same row. > > For example: if user enter the value is in PRA Sheet column M8, > userform will write the value in cell T8:AA8, same as if

Re: $$Excel-Macros$$ User form value in current active row

2011-02-06 Thread Manish
Dear Paul & EE, I want to write the value of userform in same PRA worksheet in column T:AA in same row. For example: if user enter the value is in PRA Sheet column M8, userform will write the value in cell T8:AA8, same as if user enter the value in PRA Sheet column M11, I want to write the userfo

Re: $$Excel-Macros$$ User form value in current active row

2011-02-01 Thread Manish
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 > > >

Re: $$Excel-Macros$$ User form value in current active row

2011-01-31 Thread Paul Schreiner
XCEL AND VBA MACROS 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 a

Re: $$Excel-Macros$$ User form value in current active row

2011-01-31 Thread Manish
erform, 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 > > > Fro

Re: $$Excel-Macros$$ User form value in current active row

2011-01-25 Thread Paul Schreiner
into an Oracle database.. it takes a while) Paul From: Manish To: MS EXCEL AND VBA MACROS 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 ce

Re: $$Excel-Macros$$ User form value in current active row

2011-01-25 Thread Manish
To: MS EXCEL AND VBA MACROS > 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 l

Re: $$Excel-Macros$$ User form value in current active row

2011-01-25 Thread Paul Schreiner
7;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 To: MS EXCEL AND VBA MACROS Sent: Tue, January 25, 2011 1:37:03 AM Subject: $$Excel-Macros$$ User f

$$Excel-Macros$$ User form value in current active row

2011-01-24 Thread Manish
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