Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,HELP
|
|||
|
|||
![]()
I am a beginner and I am trying to write a conditional
statement that verifys whether or not a cell has a value greater than zero. If it does, the program contiues to the output page. If it doesnot, a separate error sheet pops up that directs the user to return to the sheet and enter a value. The error sheet appears evey time even if thecell is greater than zero. 2 Questions. 1. Is their a better way to do this with a message box that would appear as opposed to referring it to a separate sheet, and; 2. What is the problem with my program (see below) Sub Continue_inputs_to_outputs() ' ' Continue_inputs_to_outputs Macro ' Moves the user from the input sheet to the output sheet provided all the information is complete ' Sheets("Input Fields Competitve").Select If Labor_cost 0 Then Sheets("LPA Competitive Output").Select ActiveWindow.SmallScroll Down:=-15 Range("G4:R5").Select Else Sheets("Warning Page").Visible = True Sheets("Warning Page").Activate Range("i20").Select End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional If Statements | Excel Discussion (Misc queries) | |||
Conditional If Statements | Excel Worksheet Functions | |||
Conditional statements | Excel Worksheet Functions | |||
Conditional Statements Help! | Excel Discussion (Misc queries) | |||
Conditional statements | Excel Worksheet Functions |