LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 273
Default Formula help

Hello, I have a form in my excel workbook that is brought up by a buttons on
click event. On this form I have 5 text boxes.
1) txtMinutesWorked
2) txtRunMinutes
3) txtDelayMinutes
4) txtDelayHours
5) txtDelayInDecimal

Here is an example calculation of what im looking for the form to calculate.
If I enter 480 into €śtxtMinutesWorked€ť and I enter 240 into €śtxtRunMinutes€ť
then €śtxtDelayMinutes€ť would calculate a number 240 and €śtxtDelayHours€ť would
calculate a number 4h 0m and €śtxtDelayInDecimal€ť would calculate 4.0. What
VBA would I put in what boxes to get the numbers I need calculated? I have
this working on a worksheet but I wanted to do it in a popup in VB..

Thanks!

--
Newbies need extra loven.........
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"