Log In
Register
Home
June 26, 2016
Offline
Hello everyone My name is Maurizio
And my problem is this:
My daughter has given me a damanda here I can not answer with all my good will; Here is explained the reason for my request.
The problem is this; Always taking advantage of the VBA it would be possible to take for good that in the Column (B) I can write any data in any cell; And only at this point in the previous cell to my Venga inserted automatically (today's date)
I bring an example: If in the Cell (B8) of the sheet of excel I write (1936,27 €) Or the word (Dog)
Nlla Cella (B7) should automatically appear on today's date.
So it should happen in the cell Example (B30) Write the name (Armando)
In the Cell (B29) It should always appear today's date etc ...!
According to you all this and possible to create all this.
Thank you for all the help you want to give me about; Greetings from A.Maurizio
VIP
Trusted Members
June 25, 2016
Offline
Hi Maurizio
See attached.
It will add today's date above any cell that you enter data in column B.
Hope your daughter like it.
Sunny
June 26, 2016
Offline
Thank you Infinite SunnyKowMy children thank you, but I congratulate you as I did this way I would never have succeeded.But if I can still dare your kindness; I can ask you what you think is wrong with this function.The other day I wanted to try to solve what you did from me.And I wrote:Dim MyDato as StringIf range ("B" & MyDato, "D"). Value> 0 thenBut just on this (If Then) keeps giving me error when I start the Why procedureThank you Infinite of All Sincere Greetings from A.Maurizi(P.S) SunnyKow You are a Great
VIP
Trusted Members
June 25, 2016
Offline
Hi Maurizio
Could you post the full code as the code you have given is insufficient to test.
Sunny
Trusted Members
Moderators
November 1, 2018
Offline
range("B" & MyDato, "D"). Value
is not valid syntax, as you have mixed up Range and Cells syntax. Assuming MyDato is a row number, you would either refer to range("B" & MyDato) or to Cells(MyDato, "B")
June 26, 2016
Offline
Hello Velouria
Thank you for your Tip this Rule with the (Range) written in this way I did not know it.
However: I would like to reiterate that my function I knew at the outset that it was wrong.
But with it, I just wanted to point to any cell of the three columns taken at random that were (B: C: D) in it I did not aim to insert a line number, but to any given data.
Example: I took into account the Cell (B7) or the Cell (D2) and I wrote a data like: "Home" or "Sea" and then I pressed the Enter key from Keyboard; The program should have Given today's date in cell (B6); Ditto for the Cell (D1) everything here.
But hora Thanks to you I have solved this problem and I understood where I was wrong, For so much Thank you so much more of everything; Greetings and a Thanks Sincere everyone by A.Maurizio
1 Guest(s)
