Re: $$Excel-Macros$$ VBA for Data Validation Question

2013-08-02 Thread Deepak Barnwal
PFA Is this what you are looking for. If not send an example file. Regards Deepak On Thu, Aug 1, 2013 at 10:26 PM, RJQMAN rjq...@gmail.com wrote: I am not sure if this is the proper way to reply, so forgive me if I am not doing this correctly. I thought I posted the code but perhaps I did

Re: $$Excel-Macros$$ VBA for Data Validation Question

2013-08-02 Thread RJQMAN
Hello Deepak While trying to figure out how to post everything you need, I found a solution to my problem. By trial and error, I stumbled on a VBA code solution that works as follows; Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit

Re: $$Excel-Macros$$ VBA for Data Validation Question

2013-08-01 Thread De Premor
Just trying to imagine with your problem since there is no file attached to explore the other scene. PFA my first approach, is that close with your ? Pada 01/08/2013 8:54, RJQMAN menulis: I have a complex program I wrote in Excel 2003 about six years ago, and I am working to update it. In

Re: $$Excel-Macros$$ VBA for Data Validation Question

2013-08-01 Thread RJQMAN
I am not sure if this is the proper way to reply, so forgive me if I am not doing this correctly. I thought I posted the code but perhaps I did not do it correctly. My cell formula was simple in column C - I just use Isnumber to check and make sure that there was a number in both column A and

$$Excel-Macros$$ VBA for Data Validation Question

2013-07-31 Thread RJQMAN
I have a complex program I wrote in Excel 2003 about six years ago, and I am working to update it. In the program, I am concerned about the sum of data entered into two columns and totaled in the third column. There are about 60 groupings of cells, all independent, with about 25 sets of cells