Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to use a button to send a workbook on a condition of cell
F7 having the value of 15 or more. If the value is less than 15, a msgbox displays telling the user to populate all fields in order for them to send. If the value equals 15 or more, an e-mail window opens with the workbook attached. Currently, everytime i click the submit button, it gives me the msgbox and does nothing else regardless of what value is in F7. Here's the code I have written so far: =========================================== Private Sub Send_Click() If ( F7 < 15 ) Then MsgBox ("You must populate all required fields to send.") Else ActiveWorkbook.SendMail Recipients:=MailTo End If End Sub =========================================== Suggestions please? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I evaluate A1 from cell A2 and place a value into A3? | Excel Discussion (Misc queries) | |||
evaluate cell value with sheet name | Excel Worksheet Functions | |||
Evaluate Range of Cell | Excel Programming | |||
Evaluate a cell evalute 3 cell based on result | Excel Programming | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions |