Posts by rkayasth

Friends,

I have a button "Transfer", on whose click and according to the value selected in cell C5 of "Daily" sheet, it should copy the values to F4 for "Jan" selected, to G4 for "Feb" selected, and so on.

I have tried to code using case statements, but I am getting some error.

Experts, pl suggest.

Thanks in advance........

Hi Guru's

Pl refer the attached excel....A macro button to this answer is acceptable...
To be brief, I want to pickup the Credits / Debits of amount column only for those entries having "EBA/NSE N...." words in the "Txn Description" column, and want to perform additions for credits txn (Cr) and substractions for debit txn (Dr).
At the end, I should have one figure after doing addition & substraction.

Thnx in advance...

Regards

Ravin kayasth

Re: validation of multiple textboxes

Hi Andy,

Thnx for the reply..But partly solved...
1. still form does not exit on clicking ok...
2. a small modification needed, what happens is, Now if I click "Cancel" it still prints the values in the columns...I dont want that

Your help is gr888ly appreciated..

Thnx again..

Ravin

Re: validation of multiple textboxes

::bump

Re: validation of multiple textboxes

Hi All,

I did manage to make some changes, it works, but the problem, is after clicking the "OK", it doesnt end the userform, and also, I did like to roll back the changes if "Cancel" is clicked.
The steps for teting this sheet remains the same as above.

Thnx
Ravin

Hi all gurus,

I have 2 textboxes, wherein I want them to be validated for Only numeric entries, and also that they should not be empty.
I can write 2 procedures for that, but then thats efficient coding...
In the attached worksheet,
step 1) select M+R in column 2
Step 2) make some entries in the 2 textboxes.

I have written some code, but thats not working...

Thnx in advance

Re: UserForm initialize code closes UserForm

Hi,

Can somebody send the file mentioned in the first post??
I am facing a similar problem...hope to get some lead from that...
Rk

Re: Referenced value in a cells in 5 rows

:: bump

Re: Referenced value in a cells in 5 rows

Hi Maqbool:
Thnx for your reply, the code is now working all right....
But just one last help.... I want to shift the columns, where it is printed to another 2-3 columns, I tried a whole day, but could not get it right, somewhere it gets screwed up, I am attaching your part of the code...

'For printing the Recurr additional Value
                            If Target.Column <> 2 Or Target.Cells.Count > 1 Then Exit Sub
                               If Target.Value = "M + R" Or Target.Row = 3 Then
                                   Set rngtoFill = Range(Target.Offset(0, 5), Target.Offset(5, 5))
                                   chkData = Application.WorksheetFunction.Count(rngtoFill)
                                   If chkData = 0 Then
                                   MsgBox ("chkData")
                                       rngtoFill.Value = Worksheets("Interest Calculations").Range("F4").Value
                                   Else
                                   MsgBox ("1st Else")
                                       If Target.Offset(0, 6).Value = "" Then
                                       MsgBox ("Inside If")
                                           lstCol = Target.Offset(0, 6).Column
                                           Range(Cells(Target.Row, lstCol), Cells(Target.Row + 5, lstCol)).Value = Worksheets("Interest Calculations").Range("F4").Value
                                       Else
                                       MsgBox ("2nd Else")
                                           lstCol = Target.Offset(0, 5).End(xlToRight).Column
                                           Range(Cells(Target.Row, lstCol + 1), Cells(Target.Row + 5, lstCol + 1)).Value = Worksheets("Interest Calculations").Range("F4").Value
                                       End If
                                   End If
                               End If

Please help....

Regards
Ravin

Re: Referenced value in a cells in 5 rows

::bump

Re: Addition of values in a Single cell

HI Wigi...

It worked!!!! thnx a ton....

Re: Referenced value in a cells in 5 rows

Hi Maqbool,

Sorry for bothering you again, but the code failed in its task after a couple of tests.
The problem is, after entering the values in "Col B" as "M+R", for 3-4 times, the value to be put in "Col J" (viz; 150), as per your code, it is appending after the 2nd time...
You can try in the attached sheet:
Step1: Select "M+R" in Col B.
Step 2 : Enter some value in the popup (E.g 1000)
Step3: You will see "150" being put in the "Col J"
Step4: Repeat the same for 3-4 time and observe "Col K". It will keep appending...

What I want is, everytime the value to be put in a new column, if the value already exists in the "Col J" (i.e starting column) or any column thereafter....

The result sheet give the picture of What I want....

Re: Addition of values in a Single cell

Hi Derk,

I had attached the sheet in my question...
I am a bit confused in where to add the function, you have suggested...
And how will that function work only for Column F??

Hi All,

Pl see the attached sheet.
It already has some example....I need the result of the addition in the cells of column F, at the side Say column G, in the coressponding row. e.g for cell F9, I need the result in G9, and so on.

For testing,
step 1. Select M+R in Col "TOI", enter some value in the pop up.
step 2. Again select M+R in "TOI", enter some value in the pop up. the Col F will have some additions (e.g 1+2), for which I need the result in the corresponding next column. i.e col G.

Re: Referenced value in a cells in 5 rows

Hi Maqbool,

Thnx buddy, your code help and I got what I wanted....m sorry, was trying to explain, but may have missed some point..

Thnx again..

Ravin

PS: Moderator, This thread can be closed....

Re: Referenced value in a cells in 5 rows

HI Maqbool,

The previous file attached gives error.
U can try this file. The correct one.
You have to do the following..
Your previous code was also working fine, except that from the "YOI" 2005, it was not adding to another column but adding to the 2nd one only.
I have attached the excel.
Steps:
1) Select M+R in the YOI-2002 enter some value in the pop-up. it will print "150" in the Col G.
2) Select M+R in the YOI-2003 enter some value in the pop-up. it will print "150" in the Col H.
3) Select M+R in the YOI-2004 enter some value in the pop-up. it should print "150" in the Col I.

But it does not.....

Thnx again for the help...

Re: Referenced value in a cells in 5 rows

Hi Maqbool,

Your previous code was also working fine, except that from the "YOI" 2005, it was not adding to another column but adding to the 2nd one only.
I have attached the excel.
Steps:
1) Select M+R in the YOI-2002 enter some value in the pop-up. it will print "150" in the Col G.
2) Select M+R in the YOI-2003 enter some value in the pop-up. it will print "150" in the Col H.
3) Select M+R in the YOI-2004 enter some value in the pop-up. it should print "150" in the Col I.

But it does not.....

Thnx again for the help...

Re: need to put referenced value in a cells in 5 rows

Hi Maqbool

I understand that...
If there is a value in that range, it should go to next column, and put the values there..
Basically the check of If (Isempty)...
But I am not able to get that right.....

Thnx again....

Re: need to put referenced value in a cells in 5 rows

Thnx Maqbool,

Your code worked, except, it overwrites the existing value in the cell.How can I prevent that??

PL help....

I understand that, but then nobody answerred my query, and I posted a bump also, but then also nobody answered.
Anyway, I will keep in mind

Ravin

Re: need to put referenced value in a cells in 5 rows

::bump