Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
thanx bob ur code works...
but now how do i change it to go and check on sheet named "inputpage" for row a and b? im going to put a cmdbutton on about 10 or 12 sheets and need this macro to then go and check on the "inputpage" for that word/number combination much appreciated Sub Test() Dim mpRow As Long Dim mpWord As String Dim mpResult As Double mpRow = Int(Rnd() * 25 + 1) mpWord = Cells(mpRow, "A").Value On Error Resume Next mpResult = InputBox("provide a number for " & mpWord) On Error GoTo 0 If mpResult < 0 Then If mpResult < Cells(mpRow, "B").Value Then MsgBox "Wrong" Else Cells(mpRow, "A").Value = "" End If End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting fileterd cells with spesific value | Excel Worksheet Functions | |||
Openning spesific file in Excel | Excel Discussion (Misc queries) | |||
verify if spesific sheet exist | Excel Discussion (Misc queries) | |||
Go to spesific letter in a list | Excel Discussion (Misc queries) | |||
How to get exact hours above a spesific time? | Excel Discussion (Misc queries) |