Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-03 Thread Abhishek Jain
Yes. It will take time. The code and everything is already there. You just need to create the userform. And you would good understanding if you create it yourself. On Fri, May 3, 2013 at 5:35 PM, Prafull Jadhav wrote: > Dear Abhishek Sir, > > I have just seen web site ..it it good one. > > I w

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-03 Thread Prafull Jadhav
Dear Abhishek Sir, I have just seen web site ..it it good one. I will practice the same ...i know it will take time to understand the whole funda as I am new for the same. thanks a lot Sir Reg, Prafull Jadhav. On Fri, May 3, 2013 at 5:14 PM, Abhishek Jain wrote: > If you're willing to do

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-03 Thread Abhishek Jain
If you're willing to do some work by yourself, this is an excellent example. Give it a try and tell me if you need help. http://www.excel-vba-easy.com/vba-userform-excel-vba.html On Fri, May 3, 2013 at 5:04 PM, Prafull Jadhav wrote: > Dear Sir, > > Can i get example file so i can practice on i

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-03 Thread Prafull Jadhav
Dear Sir, Can i get example file so i can practice on it i want to learn macro ,form.which is related to excel VBA. Regards, Prafull Jadhav. MIS exceutive. On Fri, May 3, 2013 at 4:57 PM, Abhishek Jain wrote: > Dear Prafull, > > In this example, no it does not get stored anywhere. Pan

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-03 Thread Abhishek Jain
Dear Prafull, In this example, no it does not get stored anywhere. Pankaj had only asked for restriction part. However, in his original form, yes, it should get stored otherwise there is no purpose of having such forms. Regards, On Fri, May 3, 2013 at 4:39 PM, Prafull Jadhav wrote: > Dear Pank

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-03 Thread Prafull Jadhav
Dear Pankaj,abhishek Sir, I have one query ..the infomration which we feed ..is it stored any where...? (I am new for Macro and VBA) Regards, prafull Jadhav. On Thu, May 2, 2013 at 2:49 PM, pankaj gmail account wrote: > Thank You Abhishek Great! > > I was just looking for the same. > > in futu

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-02 Thread pankaj gmail account
Thank You Abhishek Great! I was just looking for the same. in future I will try to provide a sample query or form.. Regards, Pankaj Michael On Thu, May 2, 2013 at 11:28 AM, Abhishek Jain wrote: > Dear Pankaj, > > Please see attached. Hope this is what you are looking for, if not, let me > know

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread Abhishek Jain
Dear Pankaj, Please see attached. Hope this is what you are looking for, if not, let me know. However, it is advisable to have a sample file for your query ready with you, particularly for VBA and User Form related problems. You would appreciate that in this forum people voluntarily take time and

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread pankaj gmail account
in VBA Form. Regards, Pankaj On Wed, May 1, 2013 at 4:30 PM, ravinder negi wrote: > please give more detail with example file so we can understand properly > whether you want this in VBA for or normally in excel sheet. > > > --- On *Wed, 5/1/13, pankaj gmail account * wrote: > > > From: pankaj g

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread pankaj gmail account
Dear Priti, I want user restriction in Excel GUI form. Regards, Pankaj On Wed, May 1, 2013 at 2:59 PM, priti verma wrote: > Hi Pankaj, > I thing you want data validation thats restrict to enter the name in to > the column of phone number.and to restrict the phone number to enter into > columns

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread ravinder negi
please give more detail with example file so we can understand properly whether you want this in VBA for or normally in excel sheet. --- On Wed, 5/1/13, pankaj gmail account wrote: From: pankaj gmail account Subject: $$Excel-Macros$$ Fwd: Mandatory Cell Entry To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread Abhishek Jain
Hi Pankaj, If you have a sample file and form ready, I can help with VBA. Please share. Regards, On Wed, May 1, 2013 at 2:30 PM, pankaj gmail account wrote: > > > -- Forwarded message -- > From: pankaj gmail account > Date: Sat, Jan 5, 2013 at 9:10 AM > Subject: Mandatory Cell

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread priti verma
Hi Pankaj, I thing you want data validation thats restrict to enter the name in to the column of phone number.and to restrict the phone number to enter into columns of name. am i right or not. Regards, Priti verma On Wed, May 1, 2013 at 2:30 PM, pankaj gmail account wrote: > > > -- Forw