Hello again (naturally...),
I have this sheet and in some cells I have a time calculting formula like this one:
I input the data in this sheet via a Userform. I would like to be able to calculate the times via vba and not via the formulas in the sheet.
Please Login or Register to view this content.
is it possible? if so... how?
thank you for any help.
Try this, it's easier then explaining
http://mikevba.altervista.org/macro/mikevba108.php
Buona fortuna
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
calculate the times as a variable and then you can assign it to any cell you want
Please Login or Register to view this content.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
hello Saravnepali,
I have tried implementing your solution but without much of a success. Below please find my code. Can you please tell me where to insert it?
Please Login or Register to view this content.
Attach your workbook - instructions in the yellow banner at the top of the page.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
I have attached a file. "Flight Report" is where I need the formulas to appear. Right now the formulas are in the cells but I would like the sheet not to have any formulas in it, this to prevent errors.
also... is it possible to have a code that no matter what somebody inserts in the userform's textbox1, 2, 4 and 5, what appears in "Flight Report" is alwasy hh:mm? so if somebody insert 0230 or 02.30 it will be 02:30
I am sure that you have a computer screen that can manage the entire userform.
What you need to do is force the correct time input in each userfom textbox where only time values are allowed.
I see Landin and ATA but if you attach a screen shot with all the fields that require a time-input, I'll try my best to help you and also make sure that the userform zooms to fit any computer screen you use.
Attachment 652288
Hello "Howbeautiful"
Attachment is not visible for me, invalid attachment, please attach files as indicated in the forum rules
Attachment 652315
it is strange, I have followed the instructions and I can see the attachment when I click on it...
anyways... second try....
Same problem. check for errors when attaching. but anyway, try this, hope it works as I think it should and that you can use it.
Ciao Mauro,
With your idea and question implemneted
A domani.
Hans
The latest version, playing around with VBA and it's possibilities
Same version number but more elaborated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks