Hello.
I have a code that have to fill a textbox with the value of last non empty cell from column F in active sheet.
This code doesn't work, the textbox in frmInregistrare remain empty.
The cause is because cells from column F isn't really empty, all cells have formulas.
I think I know which is the wrong line but I don't know how it have to be modified.
Could you help me, please?
I've attached an example.
Thanks.
The code that I have is follow:
Please Login or Register to view this content.
The .Find method can return the last used cell value excluding null strings (i.e. "")
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Perhaps something like this??
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Both of codes work perfectly.
Thank you @AlphaFrog and @MarvinP.
The following code also works fine.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks